SQL Server index hint

[Former Member]

Hi,

We have performance problem when transferin data from SCM system.

We have the following suggestion from SAP.

I figured out that a wrong index is used in the select statement.

This is a well known issue in SQL2000, I think in SQL2005 this would

not occur. You can tell the optimizer to use the correct

index by using an index hint according to note 133381.

Instead of AUSP_{1 the index Ausp}0 should be used because it is much

more selective.

Note 133381 tells about usage of Hints in Open SQL.

Is there a way to force SQL server to use different index without modifying ABAP programs?

Any help will be useful.

Best Regards

[markus_doehr2 · Accepted solution]

This is not possible but using a hint (that´s what hints are for).

Why not upgrade to SQL 2005 if you don´t want to modify the program?

Markus