Intro / why?
Search query performance depends on our ability to utilize the OS page cache effectively to keep search indexes hot. The smaller the size of your indexes, the easier it will be for the OS to maintain them in memory.
This article shows 6 tactics that can be used to minimize the size of your DSE Search index.
Here are the tactics you can employ to minimize your DSE Search index size:
- Turn off Term Vector information if you're not using highlighting or other functionality that relies on it:
- Turn on omit norms if you're not using Boosts:
Note: From what I've seen term vectors and omit norms can be a substantial percentage of your index ~50%
Only index fields you intend to search. Most use cases don't require users to index all their fields for search.
Make sure you're not indexing your
_partition_key(this may happen by default in modern DSE versions):
<field name="_partitionKey" type="uuid" indexed="false"/>
Use StrField rather than TextField (no tokenizers)
TrieField precisionStep - A higher precision step will increase query latency but it will decrease the index size.
Learn more about your indexes
You can also introspect your indexes using Luke. Luke is bundled in DSE so you can access it from a browser by hitting: