Re: PL/SQL Performance Issue or Slow Cursor?

Hi.

1. Use EXPLAIN window of PLSQL Developer to get EXPLAIN PLAN and post it.
2. What indexes do you have on P_TYPES table? Post:
   • Tables definitions
   • Index definitions ( Do you have an index on P_TYPES table with ID as leading column?)
   • Output of query "SELECT * FROM user_tables WHERE table_name in ('P_TYPES','TEMP_RESULT_TABLE')"

DECLARE
 CURSOR c_search IS

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