Thread: Force query to use index

Can you force a query to use a specific index?

Can I for instance say:

select * from tableA where user = 'soandso' and someint = -1 and somedata = 
'foo' ;

and somewhere in that query tell it to use the tableA_suchandsuch index?


-Dennis