Re: Unique index not being used, up to date stats

On 26.01.2007 16:02, Ben wrote:
> Yeah, I use
> dbms_stats.gather_schema_stats(
> ownname => 'PRODDTA',
> cascade => true,
> degree => 6,
> options => 'GATHER STALE');
>
> This runs every weekend, and the table in question & indexes were
> analyzed this past weekend.

One more idea: did you verify that the data actually meets your expectations? You could do

select sum(case when wadoco >= 11723420 then 1 else 0 end) "selected" , sum(case when wadoco >= 11723420 then 0 else 1 end) "not selected" FROM proddta.f4801

to make sure that your idea of the data matches reality.

Are there any stored outlines (stored plans) around?

Kind regards

        robert Received on Fri Jan 26 2007 - 09:07:52 CST