Re: Help with our sql tuning

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