Mega Code Archive

Autotrace ctxsys context index

SQL> SQL> SQL> create table t ( x clob ); Table created. SQL> SQL> set autotrace traceonly explain SQL> select * from t; Execution Plan ---------------------------------------------------------- Plan hash value: 1601196873 ---------------------------------- | Id | Operation | Name | ---------------------------------- | 0 | SELECT STATEMENT | | | 1 | TABLE ACCESS FULL| T | ---------------------------------- Note ----- - rule based optimizer used (consider using cbo) SQL> SQL> create index t_idx on t(x) indextype is ctxsys.context; Index created. SQL> select * from t; Execution Plan ---------------------------------------------------------- Plan hash value: 1601196873 ---------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost | ---------------------------------------------------------- | 0 | SELECT STATEMENT | | 82 | 8200 | 1 | | 1 | TABLE ACCESS FULL| T | 82 | 8200 | 1 | ---------------------------------------------------------- Note ----- - cpu costing is off (consider enabling it) SQL> SQL> set autotrace off SQL> SQL> drop table t; Table dropped.