Time query for a huge table : Timing « SQL Plus « Oracle PL / SQL






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

1.Time command
2.Time and autotrace a big table
3.time a query with where clause
4.Time lower text function
5.Loop timing
6.timing unconditional loop
7.Statistics query Timing on index
8.Performace difference between sql and pl/sql
9.TIMING table copying
10.Timing passing table collection parameter to a procedure