Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

can we have a hint for Microsoft SQL Server

Hi All,

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.




Look at OSS <a href="">Note 133381 - Database-Hints in Open SQL for MS SQL Server</a> (Basic note is <a href="">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>)'.


0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question