Introduction On SQL Server, you can use index hinting to force the server to use a particular index when executing queries for FINDFIRST, FINDLAST, FINDSET, FIND('-') , FIND('+') , FIND('=') and GET statements. Queries generated by the form runtime will be affected by index hints in the same way. Index hinting can help avoid situations where SQL Server’s Query Optimizer chooses an index access method that requires many page reads and generates long-running queries with response...