PL/SQL procedure successfully completed. RPT ---------------------------------------------------------------------------------------------------------------------------------------------------------------- LEGEND: ....... EQ : Used in single table EQuality predicate RANGE : Used in single table RANGE predicate LIKE : Used in single table LIKE predicate NULL : Used in single table is (not) NULL predicate EQ_JOIN : Used in EQuality JOIN predicate NONEQ_JOIN : Used in NON EQuality JOIN predicate FILTER : Used in single table FILTER predicate JOIN : Used in JOIN predicate GROUP_BY : Used in GROUP BY expression ............................................................................... ############################################################################### COLUMN USAGE REPORT FOR U.ORDS .............................. 1. CATEGORYID : EQ 2. STATUS : EQ ############################################################################### Session altered. TRACEFILENAME -------------------------------------------------------------------------------- /u01/app/oracle/diag/rdbms/db12201/db12201/trace/db12201_ora_20607_STATS.trc Session altered. Session altered. PL/SQL procedure successfully completed. done gether stats on U.ORDS Session altered. TRACEFILENAME -------------------------------------------------------------------------------- /u01/app/oracle/diag/rdbms/db12201/db12201/trace/db12201_ora_20607_STATS.trc BASE ----------------------- db12201_ora_20607_STATS created file: db12201_ora_20607_STATS.tkp TABLE_NAME BLOCKS NUM_ROWS ------------------------------ ---------- ---------- ORDS 35 10000 INDEX_NAME LEAF_BLOCKS NUM_ROWS DISTINCT_KEYS ------------------------------ ----------- ---------- ------------- ORDS 20 10000 10000 CATEGORY_IDX 21 10000 1000 STATUS_IDX 28 10000 2 COLUMN_NAME NUM_DISTINCT DENSITY HISTOGRAM NUM_BUCKETS ------------------------------ ------------ ---------- -------------------- ----------- ORDID 10000 .0001 NONE 1 CATEGORYID 1000 .001 NONE 1 STATUS 2 .00005 FREQUENCY 2 Session altered. TRACEFILENAME -------------------------------------------------------------------------------- /u01/app/oracle/diag/rdbms/db12201/db12201/trace/db12201_ora_20607_STATUS.trc Session altered. ORDID ---------- 10000 PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------- EXPLAINED SQL STATEMENT: ------------------------ select ordid from ords where status = 'PENDING' Plan hash value: 1807741764 ---------------------------------------------------------- | Id | Operation | Name | ---------------------------------------------------------- | 0 | SELECT STATEMENT | | | 1 | TABLE ACCESS BY INDEX ROWID BATCHED| ORDS | | 2 | INDEX RANGE SCAN | STATUS_IDX | ---------------------------------------------------------- 14 rows selected. Session altered. Session altered. TRACEFILENAME -------------------------------------------------------------------------------- /u01/app/oracle/diag/rdbms/db12201/db12201/trace/db12201_ora_20607_CAT.trc Session altered. ORDID ---------- 1000 4000 2000 3000 5000 6000 9000 7000 8000 9 rows selected. PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------- EXPLAINED SQL STATEMENT: ------------------------ select ordid from ords where categoryid = 0 and status = 'COMPLETE' Plan hash value: 4003840987 ------------------------------------------------------------ | Id | Operation | Name | ------------------------------------------------------------ | 0 | SELECT STATEMENT | | | 1 | TABLE ACCESS BY INDEX ROWID BATCHED| ORDS | | 2 | INDEX RANGE SCAN | CATEGORY_IDX | ------------------------------------------------------------ 14 rows selected. Session altered. Session altered. TRACEFILENAME -------------------------------------------------------------------------------- /u01/app/oracle/diag/rdbms/db12201/db12201/trace/db12201_ora_20607_GBY.trc Session altered. STATUS NUMORDS ---------- ---------- PENDING 1 COMPLETE 9999 PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------- EXPLAINED SQL STATEMENT: ------------------------ select status, count(*) numords from ords group by status Plan hash value: 2646568621 -------------------------------------------- | Id | Operation | Name | -------------------------------------------- | 0 | SELECT STATEMENT | | | 1 | HASH GROUP BY | | | 2 | INDEX FAST FULL SCAN| STATUS_IDX | -------------------------------------------- 14 rows selected. Session altered.