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: