Performance considerations

The execution time to explain a plan or package depends on the number of rows in the accessed PLAN_TABLE. If the table has many rows, you can improve performance by creating an index on PROGNAME, QUERYNO. Alternatively, delete unnecessary rows from your PLAN_TABLE.