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 -> Re: Help with our sql tuning

Re: Help with our sql tuning

From: Herman de Boer <h.de.boer_at_itcg.nl>
Date: 14 Feb 2002 00:04:49 -0800
Message-ID: <bde5777e.0202140004.fa384b1@posting.google.com>


Hello Mike,

in your query, there is the following condition:
>>> AND I.SITE_ID = :b4

However, there is no SITE_ID column in the view definition.

Could you provide the correct view definition?

Another question: are you running first_rows or all_rows optimizer_mode?

Kind Regards,

Herman de Boer.
sr consultant
IT Consultancy Group bv Received on Thu Feb 14 2002 - 02:04:49 CST

Original text of this message

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