can we have a hint for Microsoft SQL Server
Could I have a explicit hint declaration for SQL Server.
I know that we could use
%_HINT ORACLE 'INDEX... for oracle and
%_HINT DB2 'INDEX ..for db2
but, what is it for SQL Server.
Appreciate your help.
Raymond Giuseppi replied
Look at OSS <a href="https://service.sap.com/sap/support/notes/133381">Note 133381 - Database-Hints in Open SQL for MS SQL Server</a> (Basic note is <a href="https://service.sap.com/sap/support/notes/129385">Note 129385 - Database hints in Open SQL</a>
Index selection is controlled using the table hint "INDEX(index_val [,...n])" as described in Books-On-Line.
In addition the MSSQL db interface provides another way to specify which index to use. This feature allows a hint syntax like this:
o %_HINTS MSSQLNT 'TABLE <tablename> INDEX(<suffix>)'.