Re: optimizer mode

In article <eM5P8.24766$j65.597564_at_twister1.libero.it>,  "Mark" <mbwn_at_inwind.it> wrote:

> I imported a db schema to a 7.3.4 db and the optimizer don't do what i want.
> I used a rule-based optimizer mode, and i told that on the init*.ora. I
> tried deleting statistics with
> ANALYZE TABLE table DELETE STATISTICS;
> I tried rebuilding indexes
> but it doesnt like to use the index as it usually do in the other schema.
>
> Is there something wrong?

Not enough data to answer. From what version did you import? Did you go 8/9.x -> 7.3.4 or 7.x -> 7.3.4? The optimizer has changed over version releases, so results may be unpredictable.

-- 
The underscore character does not belong in my address. You know the drill...
***
Anyone sufficiently smart enough to configure and use USEnet for research should
be smart enough to Read The Freakin' Documentation!