can we have a hint for Microsoft SQL Server

[Former Member]

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

[Former Member]

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

[Former Member]

Hi,

It is the index used for viewing the table lists easily.

thanks

[RaymondGiuseppi]

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

[Former Member]

Thanx a ton Raymond.

That was fantastic