CTAS question

From: sat0789@xxxxxxxxxxx
To: oracle-l@xxxxxxxxxxxxx
Date: Tue, 30 May 2006 16:05:59 -0700

Hello All,
 I had a very basic question regarding CTAS Vs select

One of our queries takes about 7 min to complete but if i convert that
query to write to a table using CTAS, it takes 25 sec.

Could someone please tell me how come CTAS is able to select from query
and create a table in 25 sec while just the query alone takes 7 min to
execute..

Thanks,

Sat


-- 
http://www.fastmail.fm - Same, same, but different?

--
//www.freelists.org/webpage/oracle-l

References:
- SOS : Recover from unused columns
  - From: Prabhu, K
- Re: SOS : Recover from unused columns
  - From: K Gopalakrishnan

CTAS question

Other related posts: