Re: Comparing the same SELECT in CTAS, INSERT and SELECT
- From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
- To: "Dennis Williams" <oracledba.williams@xxxxxxxxx>, hkchital@xxxxxxxxxxxxxx
- Date: Sat, 28 Oct 2006 13:10:29 +0800
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
--
//www.freelists.org/webpage/oracle-l
Other related posts: