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:21] doc |
integration:rdbms:queries [2011/04/01 16:42] deb |
||
---|---|---|---|
Line 10: | Line 10: | ||
**[[integration:rdbms:queries|Queries]]** | | **[[integration:rdbms:queries|Queries]]** | | ||
[[integration:rdbms:updates|Updates]] | | [[integration:rdbms:updates|Updates]] | | ||
- | [[integration:rdbms:creation|Generating Data Files]] | | ||
[[integration:rdbms:implementation|Implementation Guides]] | [[integration:rdbms:implementation|Implementation Guides]] | ||
Line 34: | Line 33: | ||
=== Omnidex SQL === | === Omnidex SQL === | ||
- | Queries can be submitted using Omnidex SQL. Omnidex SQL consists of ANSI SQL, supplemented with [[dev:sql:functions:home|Omnidex functions]]. Omnidex also supports some of the proprietary functions found in the relational database. 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. |
- | Some queries can benefit from rewording or restructuring, though Omnidex will attempt to optimize a query as it is originally worded. Nonetheless, 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. |