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.

Thanks,

Mohan

Tags:
Former Member
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>

Extract:

  • 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>)'.

Regards

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