Progress
DataServer
for ORACLE Guide


ORACLE Hints

The DataServer issues hints to ORACLE in the following cases:

If you create your ORACLE database using the Progress-to-ORACLE migration utility and choose the Create Extended 4GL Objects option, your tables must use the PROGRESS_RECID column instead of the native ROWID or your applications will not benefit from this performance enhancement. The combination of this enhancement and using the native ORACLE ROWID results in performance gains when your application holds exclusive locks or upgrades locks.

In general, using the native ROWID tends to help performance, though you lose the following functionality:


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