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

Home -> Community -> Usenet -> c.d.o.server -> Optimizer results

Optimizer results

From: Mitchell Jessee <mjessee_at_eli.net>
Date: Thu, 01 Apr 1999 16:59:06 GMT
Message-ID: <3703A42D.C53BC794@eli.net>


Anyone know why the explain plan would give different results between Rule and Cost when performing a simple:

Insert into <table name> ( <column list> ) values (<values list>); ?

There is no select statement, only a list of values.

I don't understand why the optimizer choice would have any effect on this statement. Received on Thu Apr 01 1999 - 10:59:06 CST

Original text of this message

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