Omnidex provides a wide variety of indexing capabilities. The simplest applications may simply require a few indexes to be added, but other applications may use many more indexing capabilities. It is useful to get a quick overview of the indexing capabilities of Omnidex. Customers commonly purchase Omnidex for its basic indexing capabilities, only to discover there is more more available.

Concepts | Options | Creation | Strategies | ActiveCounts | PowerSearch | AutoComplete | Text | Advanced | Applications —-
=== Indexing Strategies === The simplest strategy used in Omnidex is to index everything, or at least everything that is involved in the queries. This strategy immediately services a wide variety of queries. Most applications then benefit from analyzing the queries and using specific strategies for optimizing table joins, aggregations, grouping and ordering. Omnidex administrators will strive to have as much of the query processed within the index as possible. A query is consider fully optimized when all aspects are fulfilled by the indexes. In fact, queries that return counts, aggregations, or a few data columns can be fulfilled without ever accessing the data itself, even when the statements involve many table joins, complex criteria, group and ordering. More > ===== ===== —-
Prev | Next**

See also: