https://www.omnidex.com/docs/v51/ 2026-04-23T09:24:41+0000 https://www.omnidex.com/docs/v51/ https://www.omnidex.com/docs/v51/lib/tpl/simple/images/favicon.ico text/html 2012-10-26T14:57:10+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=admin:indexing:strategies:aggregations&rev=1351263430&do=diff Administration: Indexing Strategies Basic Strategies Overview | Criteria | Table Joins | Aggregations | Ordering ---------- Optimizing Aggregations Aggregations are usually optimized by creating an index containing all of the columns in the GROUP BY clause and all of the columns referenced in COUNT, SUM, MIN, MAX and AVERAGE functions. It is preferable to have the columns in the GROUP BY clause precede the columns being aggregated. text/html 2012-10-26T14:57:10+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=admin:indexing:strategies:criteria&rev=1351263430&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 2012-10-26T14:57:10+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=admin:indexing:strategies:home&rev=1351263430&do=diff Administration: Indexing Strategies Basic Strategies Overview | Criteria | Table Joins | Aggregations | Ordering ---------- Overview The basic strategy for creating indexes 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 columns. Th… text/html 2012-10-26T14:57:10+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=admin:indexing:strategies:joins&rev=1351263430&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 2012-10-26T14:57:11+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=admin:indexing:strategies:orderby&rev=1351263431&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.