Omnidex Optimization Strategies

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:

• 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