Re: Force index?

Alex Vilner wrote:
>
> Hello,
>
> Is there a way to FORCE the use of index in the SELECT query?
> We have several indexes defined on tables, used in a query.
> One index would benefit one type of query, while other benefits
> the other. It seems during EXPLAIN PLAN, that it is not using the
> index it should.
>
> Is there something like:
> SELECT x, y, z
> FROM a, b, c
> WHERE a.x = b.y
> AND b.z = c.m
> FORCE INDEX ind_a
> ?
>
> Thank you in advance.
>
> Alex Vilner

hi alex,

you should look in the documentation for HINT. you can give hints to the optimizer to force him to do things in a certain way

--
cu maxx

to reply just remove the no-spam. from my address Received on Thu May 14 1998 - 06:03:00 CDT