https://www.omnidex.com/docs/v54/ 2026-04-30T01:52:04+0000 https://www.omnidex.com/docs/v54/ https://www.omnidex.com/docs/v54/lib/tpl/simple/images/favicon.ico text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:indexing:advanced:aggregations&rev=1467153531&do=diff Administration: Indexing Strategies Advanced Strategies Overview | Criteria | Joins | Subqueries | Distinct | Aggregations | Ordering ---------- Aggregations * Composite indexes * Rollup tables * Grids: Distinct constraints Prev | Next Additional Resources See also: * Administration * Administration Basics * Omnidex Fundamentals * Omnidex Indexing text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:indexing:advanced:criteria&rev=1467153531&do=diff Administration: Indexing Strategies Advanced Strategies Overview | Criteria | Joins | Subqueries | Distinct | Aggregations | Ordering ---------- Criteria Criteria is the often the easiest aspect of a query to optimize. If all columns that are referenced in the WHERE clause are indexed, Omnidex will use those indexes to optimize the criteria. At the same time, there are advanced strategies that can help with more challenging situations. text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:indexing:advanced:distinct&rev=1467153531&do=diff Administration: Indexing Strategies Advanced Strategies Overview | Criteria | Joins | Subqueries | Distinct | Aggregations | Ordering ---------- Distinct Operations * Composite indexes * Grids: Distinct constraints Prev | Next Additional Resources See also: * Administration * Administration Basics * Omnidex Fundamentals * Omnidex Indexing * Indexing Concepts * text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:indexing:advanced:home&rev=1467153531&do=diff Administration: Indexing Strategies Advanced Strategies Overview | Criteria | Joins | Subqueries | Distinct | Aggregations | Ordering ---------- Overview A basic indexing strategy accommodates most queries, but there are advanced techniques that optimize more challenging situations. Queries with particularly complex criteria or complex table relationships can be optimized using these techniques. Omnidex also has features designed specifically to optimize distinct counts and other comp… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:indexing:advanced:joins&rev=1467153531&do=diff Administration: Indexing Strategies Advanced Strategies Overview | Criteria | Joins | Subqueries | Distinct | Aggregations | Ordering ---------- Joins Table joins can add time to a query using any database system. Omnidex has several techniques for optimizing joins. By default, indexing the primary and foreign key constraints with Omnidex allows many joins to be optimized without further effort. This is especially true for joins where a child table is being filtered based on criteria… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:indexing:advanced:ordering&rev=1467153531&do=diff Administration: Indexing Strategies Advanced Strategies Overview | Criteria | Joins | Subqueries | Distinct | Aggregations | Ordering ---------- Ordering Group By * Composite indexes * Rollup tables * Grids: Distinct constraints Order By * Composite indexes * Prev Additional Resources text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:indexing:advanced:subqueries&rev=1467153531&do=diff Administration: Indexing Strategies Advanced Strategies Overview | Criteria | Joins | Subqueries | Distinct | Aggregations | Ordering ---------- Subqueries Subqueries in the WHERE clause Omnidex has substantial support for subqueries in the WHERE clause. The the select item from the subquery should be indexed with Omnidex, as should the reference column in the outer query. Omnidex will attempt to process the subquery and automatically continue processing into the outer query solely t…