Release 10.1A: OpenEdge Data Management:
DataServer for ORACLE

> ## Enhancements overview

> You can design a DataServer application that emphasizes portability across data sources or one that optimizes the strengths of the DataServer’s interaction with a particular aspect of the ORACLE RDBMS. For example, you can write a query that gives you consistent results across databases or that takes advantage of ORACLE’s cursor management.

> In addition to influencing how DataServer applications perform through queries, you can control how the DataServer processes queries on a statement-by-statement basis. Some of the DataServer’s default behavior might not be optimal for the application you are designing. The `QUERY-TUNING` phrase and startup and connection parameters give you the ability to control query processing. In addition to reading the following sections, see the "Query tuning with connection and startup parameters" section for information on tuning queries at compile time and run time. See Appendix C, "Sample Queries," for examples of how the DataServer handles queries with and without query-tuning options.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095