Integration: Relational Databases

SQL Server

Queries

The Omnidex SQL Engine will optimize queries to take advantage of the Omnidex indexes. Many queries can be fulfilled 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 requested data resides in an index.

Other queries will require access to the underlying SQL Server data. The Omnidex SQL Engine will determine how to combine the results from the Omnidex indexes with the data from the SQL Server database. Usually, this requires that Omnidex provide SQL Server rowids or primary keys and request rows from the SQL Server tables based on those values. Other times, Omnidex may issue a more complex statement to SQL Server, asking it to perform a larger role in processing the query.

In all cases, Omnidex will access the data using standard SQL statements issued to the SQL Server libraries.

SQL Server-specific Syntax

Omnidex requires that all statements use Omnidex SQL syntax. Omnidex SQL uses ANSI SQL as a base, but also allows extensions from various databases, as well as Omnidex-specific extensions. Other SQL Server-specific syntax will cause errors when submitted to Omnidex. In these situations, the statements must be converted to Omnidex SQL.

Additional Resources

See also:

 
Back to top
integration/rdbms/sqlserver/queries.txt ยท Last modified: 2016/06/28 22:38 (external edit)