Time query for a huge table
SQL>
SQL> create table my_all_objects
2 nologging
3 as
4 select * from all_objects
5 union all
6 select * from all_objects
7 union all
8 select * from all_objects
9 /
Table created.
SQL>
SQL>
SQL> set timing on
SQL>
SQL> select owner, count(*)
2 from my_all_objects
3 group by owner;
OWNER COUNT(*)
------------------------------ --------
MDSYS 1374.00
TSMSYS 6.00
FLOWS_020100 3255.00
PUBLIC 8298.00
OUTLN 21.00
JAVA2S 603.00
CTXSYS 1014.00
HR 102.00
FLOWS_FILES 33.00
SYSTEM 1266.00
DBSNMP 138.00
OWNER COUNT(*)
------------------------------ --------
XDB 1002.00
SYS ########
13 rows selected.
Elapsed: 00:00:00.26
SQL>
SQL> set timing off
SQL>
SQL> drop table my_all_objects;
Table dropped.
SQL>
SQL>
Related examples in the same category