Omnidex Optimization Strategies

Overview → Query Plans → Query Logs → Benchmarks

Many of the optimization strategies in Omnidex involve Omnidex indexing, but some also use features of the SQL engine. These include a wide variety of techniques that are discussed in this section:

• PowerSearch - Finding Data without Exact Criteria
• Rollup Tables - Optimizing Counts and Aggregations
• Temporary Tables - Taking Advantage of Temporary Tables
• Hashed Data Cache - Optimizing Table Joins
• Expression-based Column and Indexes - Optimizing Expressions
• Geographic Radius Searches