Re: QUERY TUNING

Ganesh Kini wrote:
>
> Can anyone suggest an approache to tune the following query which takes
> days to complete. Delc has 2.5M records with about 1.9 having not like
> '4%'. Artlc has 10M records, Article has 7M records, ProdSnap has 100K
> records of which 8K meets the condition.
> The query selects the subject headings in a product.
>
> snip

1. What does the EXPLAIN PLAN output look like?
2. What indexes are on each table?
3. Are you using Cost or Rule optimizer?
4. 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:07:14 CDT