Overview | Environments | Databases | Tables | Indexes | Queries | Updates | Stored Procedures | Example

The Omnidex SQL Engine will optimize queries to take advantage of the Omnidex indexes. Many queries can be completed entirely within the Omnidex indexes. This is especially true for queries that request counts or aggregations from one or more tables. Even queries that return columns of data can be completed using the Omnidex indexes, as long as all of the data resides in the indexes.

Many queries will require access to the underlying Oracle data. The Omnidex SQL Engine will retrieve data from the Oracle database using Oracle SQL issued using the Oracle Call Interface (OCI).

Prev | Next

See also: