Allow Index Hints in SQL by Ordinal or Tag
With Tdataset you can specify the index to use. You however can't do the same with Advantages SQL implementation as you can with others.
How to achieve this is up to your developers but it wouldn't be a bad idea to copy how it's done in other systems.
SELECT *
FROM tablename WITH (INDEX = 1)
WHERE Column1 = 'value'
OR
SELECT *
FROM tablename WITH (INDEX = tag)
WHERE Column1 = 'value'
3
votes
ahinson
shared this idea
