Databases Reference
In-Depth Information
Statistics are gathered on the index-organized table:
SQL> begin
2 dbms_stats.gather_table_stats (user
3 ,'LOOKUP_IO_T'
4 ,cascade => true
5 );
6 end;
7 /
PL/SQL procedure successfully completed.
Now everything is ready to look into the autotrace report.
Execution plan for an index-organized table
