https://www.omnidex.com/docs/v51/ 2026-04-23T09:21:15+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:07+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=admin:indexing:concepts:aggregations&rev=1351263427&do=diff Administration: Indexing Strategies Indexing Concepts Overview | Criteria | Joins | Aggregations | Ordering | Retrievals ---------- Aggregations Omnidex indexing is valuable for processing aggregations. Aggregations involve the use of the COUNT, SUM, AVERAGE, MIN and MAX functions, and may or may not include a GROUP BY clause. Omnidex first considers the type of aggregation. Queries to request a COUNT(*) without a GROUP BY clause are the simplest queries. These are optimized differ… text/html 2012-10-26T14:57:07+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=admin:indexing:concepts:alternatives&rev=1351263427&do=diff Administration: Indexing Strategies Indexing Concepts Overview | Basics | Criteria | Joins | Aggregations | Ordering | Retrievals | Alternatives ---------- Overview Omnidex provides a rich set of strategies for indexing databases. Many of these are effective without having to understand how or why they work, but others benefit from a more in-depth understanding of indexing. Omnidex's indexing technology is also quite unique in some respects, and so even the seasoned database admini… text/html 2012-10-26T14:57:08+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=admin:indexing:concepts:criteria&rev=1351263428&do=diff Administration: Indexing Strategies Indexing Concepts Overview | Criteria | Joins | Aggregations | Ordering | Retrievals ---------- Criteria Using a Single Index The most common reason to use an index is to help identify rows based on a unique value, such as a Customer ID or an Email address. All relational databases have this capability, and Omnidex does as well. Omnidex also allows you to put these kinds of indexes on raw data files or delimited files - something they don't inhere… text/html 2012-10-26T14:57:08+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=admin:indexing:concepts:home&rev=1351263428&do=diff Administration: Indexing Strategies Indexing Concepts Overview | Criteria | Joins | Aggregations | Ordering | Retrievals ---------- Overview Someone once told a story: One day, a homeowner noticed that his kitchen sink was leaking. He fiddled with the faucet and concluded that the washer needed replacing. He headed down to the hardware store, purchased the replacement washer and returned home to install it. As soon as he tried to put the new washer in, he realized that it was the… text/html 2012-10-26T14:57:08+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=admin:indexing:concepts:joins&rev=1351263428&do=diff Administration: Indexing Strategies Indexing Concepts Overview | Criteria | Joins | Aggregations | Ordering | Retrievals ---------- Table Joins Omnidex indexing is also valuable for processing table joins. Omnidex first considers the purpose of the table join. Some table joins are required to allow criteria to be processed. These are called Qualification Joins. Other table joins are required to obtain data to return to the user. These are called Retrieval Joins. text/html 2012-10-26T14:57:08+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=admin:indexing:concepts:ordering&rev=1351263428&do=diff Administration: Indexing Strategies Indexing Concepts Overview | Criteria | Joins | Aggregations | Ordering | Retrievals ---------- Ordering Omnidex indexing is also valuable for processing ORDER BY clauses. Omnidex first considers whether the ORDER BY clause requests data in ascending order or descending order. text/html 2012-10-26T14:57:08+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=admin:indexing:concepts:retrieval&rev=1351263428&do=diff Administration: Indexing Strategies Indexing Concepts Overview | Criteria | Joins | Aggregations | Ordering | Retrievals ---------- Retrieval As Omnidex optimizes a query, it looks for ways to use indexes to process criteria, table joins, aggregations and ordering. It may also find that the data to be returned to the user can be obtained from the indexes. This can allow an entire query to be processed without ever accessing the database. This technique provides exceptional performan…