CREATE TABLE HH_NC_TAB (COL NCHAR(10))insert /*+APPEND*/ into HH_NC_TAB
SELECT 'AAA'||mod(rownum, 10) FROM DUAL CONNECT BY LEVEL < 100000
union all
SELECT 'AAA'||rownum FROM DUAL CONNECT BY LEVEL < 100000commitEXEC DBMS_STATS.GATHER_TABLE_STATS(NULL, 'HH_NC_TAB', METHOD_OPT=>'FOR COLUMNS COL SIZE 254')SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY)| PLAN_TABLE_OUTPUT | Error: cannot fetch last explain plan from PLAN_TABLE |
|---|
EXPLAIN PLAN FOR SELECT * FROM HH_NC_TAB WHERE COL = 'AAA1'SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY)| PLAN_TABLE_OUTPUT | Plan hash value: 2981390417 | --------------------------------------------------------------------------------------- | | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | | --------------------------------------------------------------------------------------- | | 0 | SELECT STATEMENT | | 1 | 21 | 242 (2)| 00:00:01 | | |* 1 | TABLE ACCESS STORAGE FULL| HH_NC_TAB | 1 | 21 | 242 (2)| 00:00:01 | | --------------------------------------------------------------------------------------- | Predicate Information (identified by operation id): | --------------------------------------------------- | 1 - storage("COL"=U'AAA1') | filter("COL"=U'AAA1') |
|---|
EXPLAIN PLAN FOR SELECT * FROM HH_NC_TAB WHERE COL = RPAD('AAA1', 10)SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY)| PLAN_TABLE_OUTPUT | Plan hash value: 2981390417 | --------------------------------------------------------------------------------------- | | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | | --------------------------------------------------------------------------------------- | | 0 | SELECT STATEMENT | | 9884 | 202K| 240 (1)| 00:00:01 | | |* 1 | TABLE ACCESS STORAGE FULL| HH_NC_TAB | 9884 | 202K| 240 (1)| 00:00:01 | | --------------------------------------------------------------------------------------- | Predicate Information (identified by operation id): | --------------------------------------------------- | 1 - storage("COL"=U'AAA1 ') | filter("COL"=U'AAA1 ') |
|---|