Mega Code Archive

 

Categories / Oracle PLSQL / SQL Plus

 

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 RNTSOFT                           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>