Q: Does SQR support the use of optimizer hints for the ORACLE database?

A: SQR now supports optimizer hints in version 3. The hint must be on the first line of the Begin-Select or Begin-SQL paragraph. For example:

     begin-select
     /*+ ALL_ROWS */
     empno
     ename
     sal
     job
     from emp
     end-select

For more information about Oracle hints, see Chapter 5 - Tuning SQL Statements of the ORACLE Application Developers Guide.