This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
integration:rdbms:queries [2011/03/16 20:47] doc |
integration:rdbms:queries [2011/04/01 16:42] deb |
||
---|---|---|---|
Line 33: | Line 33: | ||
=== Omnidex SQL === | === Omnidex SQL === | ||
- | Queries can be submitted using the Omnidex SQL language. Omnidex SQL consists of ANSI SQL, supplemented with Omnidex extensions and functions. Omnidex also supports a limited number of proprietary functions found in the popular relational databases. Access to these relational database extensions can be controlled using the [[dev:sql:statements:set_sql_syntax|SET SQL_SYNTAX]] statement. Applications that have been using a particular SQL dialect from a relational database will need to adjust their syntax to Omnidex SQL. | + | Queries can be submitted using the Omnidex SQL language. Omnidex SQL consists of ANSI SQL, supplemented with Omnidex extensions and functions. Omnidex also supports a limited number of proprietary functions found in the popular relational databases. Access to these relational database extensions can be controlled using the [[dev:sql:statements:set_sql_syntax|SET SQL_SYNTAX]] statement. Applications using a particular SQL dialect from a relational database will need to have the syntax adjusted to Omnidex SQL. |
Omnidex will attempt to optimize all queries; however, like the relational databases, queries can sometimes be tuned by restructuring or reorganizing the query. Omnidex does favor certain approaches to queries. Additionally, many poor-performing relational queries have been customized by talented and hard-working database administrators to achieve the best performance for the underlying relational database. This may not lead to the best performance with Omnidex. Consult the documentation on [[admin:optimization:home|optimizing queries]] to understand more about how queries can be optimally structured for Omnidex. | Omnidex will attempt to optimize all queries; however, like the relational databases, queries can sometimes be tuned by restructuring or reorganizing the query. Omnidex does favor certain approaches to queries. Additionally, many poor-performing relational queries have been customized by talented and hard-working database administrators to achieve the best performance for the underlying relational database. This may not lead to the best performance with Omnidex. Consult the documentation on [[admin:optimization:home|optimizing queries]] to understand more about how queries can be optimally structured for Omnidex. |