Omnidex Indexes

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 each query. It is common for all criteria, table joins, aggregations and ordering to be satisfied in a coordinated effort among many indexes. Queries may not even require access to the underlying database, despite their complexity.

Three basic types of Omnidex indexes allow general SQL statement to be optimized, and also provide features including textual search, fuzzy searches and geographical searches. For advanced users, a collection of options allow access to specialized features that are useful for individual situations.

Omnidex indexes are easily created using either the Omnidex Administrator or Omnidex SQL statements. Indexes can be built in batch, greatly reducing the time required to build the indexes.

The following questions are frequently asked about Omnidex indexing:

1. What does an Omnidex index do?
2. How are Omnidex indexes different than relational database indexes?
3. What kinds of Omnidex indexes are there?
4. How to you create Omnidex indexes?