RE: Performance Difference Between != and <>?

  • From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
  • To: <srcdco@xxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 25 Sep 2006 10:17:41 -0700


Have you tried going beyond just explain & autotrace and running a full
10046 level 12 trace to see where the slower version is spending its
time?  This might shed some light on the subject, plus - be sure to
verify that the explain plans are exactly the same in the 10046 trace
file (not the ones generated with the EXPLAIN= option), and in
v$sqlplan.  There are some "features" of autotrace and explain that can
cause it to not give you an accurate explain plan.


> -----Original Message-----
> Jonathan,
>    Thank you for your answer.  We did do an explain plan on 
> both versions of the statement and they were identical, which 
> is what is so puzzling about this. 

Privileged/Confidential Information may be contained in this message or 
attachments hereto. Please advise immediately if you or your employer do not 
consent to Internet email for messages of this kind. Opinions, conclusions and 
other information in this message that do not relate to the official business 
of this company shall be understood as neither given nor endorsed by it.


Other related posts: