Trace Files — 8b : More Performance Evaluation from Trace File

Continuing with the same table as in the previous example, but with the addition of(a) Statistics on the table(b) An Index on the CREATED column SQL> select count(*) from all_objects_many_list; COUNT(*)---------- 7197952SQL> SQL> select min(created) from all_objects_many_list;MIN(CREAT---------28-AUG-11SQL> SQL> select min(created), max(created) from all_objects_many_list;MIN(CREAT MAX(CREAT--------- ---------28-AUG-11 15-NOV-15SQL> SQL> Let’s examine the tkprof output first.