How can I force ADS to use a specific index when executing a SELECT query?

Question

For example, I know how to do this in SQL Server. I can write something like the following: SELECT * FROM MyTable WITH(INDEX(MyIndex))

I didn't find anything similar for Advantage Database Server..

Answer 1

^{Converting the solution from a comment to an answer:}

There isn't anything similar in ADS. It chooses the appropriate index internally based on the columns in the query and the WHERE clause.
– Ken White  Apr 19, 2024 at 2:14