Re: PL/SQL Performance Issue or Slow Cursor?

Did you try forcing optimizer to start with TEMP_... table by using hint?

CURSOR c_search IS

        SELECT /*+ ORDERED */ PT.ID,
               PT.SET_TYPE,
               PT.LOCATION,
               PT.BACKUP,
               PT.ARCHIVE_ID
          FROM TEMP_RESULT_TABLE TRT, P_TYPES PT
          WHERE TRT.ID = PT.ID
          ORDER BY TRT.ID;

If it will not work - please post:

1. EXPLAIN plan.
2. Create table(s) statements ( with all indexes ).
3. Are you using CBO or RBO?

HTH. Michael. Received on Tue Sep 25 2001 - 14:28:17 CDT