and from 8i up.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Stan" <stan0074_at_yahoo.com> wrote in message news:3CD2E7CB.608_at_yahoo.com...
> Narendra,
>
> Don't know, what oracle versions are you in, but start looking at stored
> outlines which is a perfect thing for this requirement. fyi, this
> feature is only available on enterprise editions of oracle.
>
> hth,
> -Stan
>
> Guruju,Narendra wrote:
>
> > With out putting a hint in the query, is it possible to make a query
> > choose a particular index. The query is in a 3rd party application and
> > can not be modified, but the testing shows that if it uses a different
> > index on the table, it would run lot faster. Also the optimizer mode
> > used by the application is RULE.
> >
> > TIA,
> > Narendra
> >
> >
>
Received on Sat May 04 2002 - 11:29:42 CDT
