Mega Code Archive

Set autotrace traceonly explain, and condition

SQL> SQL> SQL> create table t 2 as 3 select mod(ROWNUM,3) a, ROWNUM b, ROWNUM c 4 from all_tables; Table created. SQL> SQL> set autotrace traceonly explain SQL> select * from t where b = 1 and c = 1; Execution Plan ---------------------------------------------------------- Plan hash value: 1601196873 ---------------------------------- | Id | Operation | Name | ---------------------------------- | 0 | SELECT STATEMENT | | |* 1 | TABLE ACCESS FULL| T | ---------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter("C"=1 AND "B"=1) Note ----- - rule based optimizer used (consider using cbo) SQL> SQL> SQL> set autotrace off SQL> SQL> drop table t; Table dropped.