Progress
DataServer
for ORACLE Guide
FIND FIRST/LAST Statements
There is a difference in performance between FIND FIRST and FIND LAST statements that access a Progress database or an ORACLE database. When you issue a FIND FIRST or FIND LAST statement in a DataServer application, the ORACLE DBMS builds a results set that might include every record in a table. To achieve comparable performance, qualify your FIND statements and queries with a WHERE clause. For example, the following statement retrieves the last record in a table.
The WHERE clause qualifies the query by specifying a recent date. ORACLE then includes only records that contain a more recent date in the results set.
The recommendation to use a WHERE clause also applies to the QUERY option. Similarly, when you use a FIND NEXT statement without first using a FIND FIRST or FIND...WHERE, ORACLE builds a results set that includes every record.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |