https://www.omnidex.com/docs/v54/ 2026-04-29T18:22:06+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:strategies:aggregations&rev=1467153531&do=diff Administration: Indexing Strategies Basic Strategies Overview | Criteria | Table Joins | Aggregations | Ordering ---------- Optimizing Count Aggregations Count aggregations are any SELECT statements that request “COUNT(*)”, “COUNT(column)”, or “COUNT(DISTINCT column)”, regardless of whether there is a GROUP BY clause. These queries are optimized using a collection of Omnidex indexes. Each column that is referenced in the GROUP BY clause and referenced in the COUNT clause must be index… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:indexing:strategies:criteria&rev=1467153531&do=diff Administration: Indexing Strategies Basic Strategies Overview | Criteria | Table Joins | Aggregations | Ordering ---------- Optimizing Criteria Criteria is usually optimized by creating indexes on each column involved in the WHERE clause of a SQL statement. This is true regardless of the use of Boolean operators or parentheses. Normally, these will be installed with basic Omnidex indexes; however, some columns may contain textual data and would benefit from QuickText indexes. text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:indexing:strategies:home&rev=1467153531&do=diff Administration: Indexing Strategies Basic Strategies Overview | Criteria | Table Joins | Aggregations | Ordering ---------- Overview The basic strategy for improving query performance is to index all of the columns that are used in criteria, table joins, aggregations and ordering. This is a different approach than is taken with relational databases. Database administrators are usually trained to identify selected columns that are most frequently used and create indexes only on those c… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:indexing:strategies:joins&rev=1467153531&do=diff Administration: Indexing Strategies Basic Strategies Overview | Criteria | Table Joins | Aggregations | Ordering ---------- Optimizing Table Joins Table joins are usually optimized by creating indexes on the table constraints. For relational databases, it is only necessary to index the foreign keys since the relational database's indexes on the primary keys will suffice. For raw data files, both the primary and foreign keys should be indexed. text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:indexing:strategies:orderby&rev=1467153531&do=diff Administration: Indexing Strategies Basic Strategies Overview | Criteria | Table Joins | Aggregations | Ordering ---------- Optimizing Ordering Ordering is usually optimized by creating an index containing all of the columns in the ORDER BY clause. The order of the column in the index must match the order of the columns in the ORDER BY clause. At present, only ascending ORDER BY clauses are optimized.