Re: How to get Oracle to an Index without hints?

Joerg Jost wrote:
>
> Niall Litchfield wrote:
>
> > This of course is the number one problem with SQL generators.
> >
> > What you *may* be able to do is to create a stored outline for the query
> > and then your query should use the plan in the stored outline. This is 8i
> > and up I believe.
> >
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
> > *****************************************
> > Please include version and platform
> > and SQL where applicable
> > It makes life easier and increases the
> > likelihood of a good answer
> >
> > ******************************************
>
> Hello Niall,
>
> sorry for my fault, the Oracle version is 7.3.4 under the OS SCO Open Server
> 5.05. And this OS donīt support any higher version of Oracle.A change of
> the OS is not really an opportunity now, because our customer wonīt invest
> so much money :-)
> Thx a lot for your help
> Joerg Jost

Don't give up just yet....

Are both indexes unique? If so, you can change the optimizeer_goal parameter to rule, and make the one you don't want to use a non-unique index.

-- 
Phil Singer                |    psinger1_at_chartermi.net
Oracle DBA

Go Wings!!!!!!!