Re: Q: why does CBO not use available indices

From: Harald Maier <maierh_at_myself.com>
Date: Mon, 06 Oct 2003 20:09:06 +0200
Message-ID: <m3vfr2qlvh.fsf@ate.maierh>

anke.heinrich_at_marconi.com (Anke Heinrich) writes:

> Hi,
>
> I have a problem getting the cost based optimizer to use the available
> indices instead of performing a full table scan. Using hints is not
> possible as I can't change the source code at the moment. I've heard
> about outlines, but I'm not sure if this works for us.
>
> I don't have much experience with query optimization or export/import
> of outlines, so any help from you is greatly appreciated.

In your case outlines are your friend. OEM has under the 'Tuning Pack' a menu entry 'Outline Management'. With that tool you should be able to edit the desired statement in a convenience manner.

Harald Received on Mon Oct 06 2003 - 13:09:06 CDT