Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> CTAS question

CTAS question

From: <sat0789_at_fastmail.fm>
Date: Tue, 30 May 2006 16:05:59 -0700
Message-Id: <1149030359.8440.262666873@webmail.messagingengine.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US