10-12-2007 6:54 AM
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
10-12-2007 7:02 AM
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
10-12-2007 7:00 AM
Hi,
It is the index used for viewing the table lists easily.
thanks
10-12-2007 7:02 AM
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
10-12-2007 7:05 AM