tMyTable use index

[777Yves]

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

[AndreyZ]

Hello,

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