Re: Comparing the same SELECT in CTAS, INSERT and SELECT

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Sat, 28 Oct 2006 13:10:29 +0800
Message-Id: <7.0.1.0.0.20061028130902.01b413e8@singnet.com.sg>

I've verified that indexes are present.

We've re-run Gather Statistics for the table. Now the SELECT operation of all three SQLs
(CTAS, INSERT and SELECT-only) runs in comparably the same time (between 1sec and 2sec
unlike the 45minutes plus the INSERT-SELECT was taking earlier) !

Hemant
At 03:06 AM Saturday, Dennis Williams wrote:
>Hemant,
>
>Just some random quick thoughts. Sounds like a foreign key
>constraint without an index? Or a primary key constraint without an
>index (don't think that is possible).
>
>Dennis Williams
>
>

Hemant K Chitale
http://web.singnet.com.sg/~hkchital

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

Received on Sat Oct 28 2006 - 00:10:29 CDT