Re: QUERY TUNING

From: Merle Martell <merle_martell_at_cargill.com>
Date: Tue, 14 Apr 1998 17:06:04 -0500
Message-ID: <3533DDCC.4E41@cargill.com>

Ganesh Kini wrote:
>
> Can anyone suggest an approache to tune the following query which takes
> days to complete.
> snip

What does the EXPLAIN PLAN output look like?
What indexes are on each table?
Are you using Cost or Rule optimizer?
What release of Oracle are you on?

You have a couple of NOT conditions, which will cause indexes to be skipped for those particular conditions. Can you reverse the LIKE to eliminate the NOT?

merle_martell_at_cargill.com Received on Tue Apr 14 1998 - 17:06:04 CDT