This is an old revision of the document!


Administration: Optimizing Queries

Configuring Omnidex

Thresholds

Omnidex has several threshold settings that control when optimizations take place. Thresholds are needed because not all queries should be optimized using Omnidex indexes. Sometimes, indexing can even slow down a query.

QUALIFICATION_THRESHOLD

The Qualification Threshold determines when indexes are used to process criteria. There are really two factors that determine when to use indexes — the nature of the statement and the number of rows.

AGGREGATION_THRESHOLD

HDC_THRESHOLD

SORTMERGE_THRESHOLD

Additional Resources

See also:

 
Back to top
admin/optimization/config/thresholds.1328830986.txt.gz · Last modified: 2016/06/28 22:38 (external edit)