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.

FIND LAST customer WHERE date > 4-20-94. 

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