CTAS question

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…

--

http://www.freelists.org/webpage/oracle-l Received on Tue May 30 2006 - 18:05:59 CDT