> ## Documentation Index
> Fetch the complete documentation index at: https://www.paradedb.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Faster Counts

> Speed up count queries for common search terms

<Note>
  This feature is available in versions `0.26.2` and above. Indexes built before
  `0.26.2` must be [rebuilt](/docs/operate/index-maintenance/reindexing) to receive
  this optimization.
</Note>

ParadeDB can speed up eligible `COUNT(*)` queries that combine common search terms
with `AND` or `OR` by storing additional bitmap structures.

## Index Configuration

The `bitmap_postings` option on a [tokenizer](/docs/reference/tokenizers/overview) cast
defaults to `true`.

It is enabled by default because the storage overhead is usually very small.
If your workload does not require counts, you can disable it for a field with
`bitmap_postings=false`:

```sql theme={null}
CREATE INDEX search_idx ON mock_items
USING paradedb (id, (description::pdb.unicode_words('bitmap_postings=false')), category);
```


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.