https://www.omnidex.com/docs/v50/ 2026-09-24T22:42:56+0000 https://www.omnidex.com/docs/v50/ https://www.omnidex.com/docs/v50/lib/tpl/simple/images/favicon.ico text/html 2012-10-26T14:26:45+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v50/doku.php?id=admin:indexing:basic&rev=1351261605&do=diff Omnidex Indexing Overview -> Indexes -> Strategies -> Advanced -> Installation -> Maintenance Basic Indexing Strategies The basic strategy for creating Omnidex 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 tables. Their general … text/html 2012-10-26T14:26:45+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v50/doku.php?id=admin:indexing:home&rev=1351261605&do=diff Omnidex Indexing Overview -> Indexes -> Strategies -> Advanced -> Installation -> Maintenance Overview Omnidex adds performance and flexibility to database applications. These benefits are achieved by a combination of the Omnidex indexes and the Omnidex SQL Engine. The indexes provide the basic speed and flexibility, while the SQL Engine analyzes statements and determines the best way to use the indexes. Omnidex is different than most SQL engines in that many indexes are used to fulfill a … text/html 2012-10-26T14:26:45+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v50/doku.php?id=admin:indexing:indexes&rev=1351261605&do=diff Omnidex Indexing Overview -> Indexes -> Strategies -> Advanced -> Installation -> Maintenance Indexes Three types of Omnidex indexes provide the bulk of Omnidex functionality. Basic Omnidex indexes are used to optimize criteria, table joins, aggregations and ordering. QuickText indexes are used to index small text fields, such as names, addresses, product descriptions and general text. FullText indexes are used to index large blocks of text. Omnidex also allows custom indexes that employ sp…