Devart Forums

Posted: **Mon 07 Feb 2011 15:22**

Hi, how could I force a specific index with a tMyTable ?
I don't want to use a something that order locally, I want to use index that are already define like in:

Code: Select all

mysql> SELECT * FROM table1 USE INDEX (key1)
WHERE key1=1;

Perhaps the answer is simply use a tMyQuery instead.

Thanks

Posted: **Tue 08 Feb 2011 15:01**

Hello,

You are right, you can use such syntax only in the TMyQuery component.

Devart Forums

tMyTable use index

tMyTable use index