This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
integration:rdbms:queries [2011/03/16 20:47] doc |
integration:rdbms:queries [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 10: | Line 10: | ||
| **[[integration:rdbms:queries|Queries]]** | | **[[integration:rdbms:queries|Queries]]** | | ||
| [[integration:rdbms:updates|Updates]] | | [[integration:rdbms:updates|Updates]] | | ||
| - | [[integration:rdbms:implementation|Implementation Guides]] | + | [[integration:rdbms:integration|Integration Guides]] |
| ---- | ---- | ||
| 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. | ||