Force which index to use

Posts   
 
    
jakkamma
User
Posts: 19
Joined: 03-Mar-2005
# Posted on: 06-Jun-2005 19:19:23   

Is there a way to force to use a specific index, that is some thing like a index hint.

The db will automatically use an Index if it can, however if we want to force the DB query plan to use another index, do we have that ability using the mapped objects ?

Thanx

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39933
Joined: 17-Aug-2003
# Posted on: 06-Jun-2005 20:19:46   

What's the database type you're using? Some database types have hints.

Frans Bouma | Lead developer LLBLGen Pro