Re: Wrong index used

From: Konstantin Kivi <kivi_at_hotmail.ru>
Date: 21 May 2001 01:31:07 -0700
Message-ID: <4f2ccffc.0105210031.50894366@posting.google.com>

john gallet <john.gallet_at_wanadoo.fr> wrote in message news:<3B04E20C.2FB4EB33_at_wanadoo.fr>...
> Hi there,
>
> > How can we fix this and what is the reason?
>
> First of all I'd try updating the statistics. Anyway, it can only help.
>
> Do that with dbms_utility.analyze_schema for all the tables of the user,
> and check out the doc for doing that on the table and the indexes only.
>

How will it help with rule based optimizer Received on Mon May 21 2001 - 03:31:07 CDT