Database-Hints in Open SQL for MS SQL Server

Example ABAP hint to use BSAS index ZSN:

SELECT * FROM bsas BYPASSING BUFFER
APPENDING CORRESPONDING FIELDS OF TABLE i_zkloan
WHERE aufnr = p_aufnr
%_HINTS MSSQLNT 'TABLE &TABLE& ABINDEX(ZSN), FASTFIRSTROW'.

additional information in oss notes: 133381, 129385, 159171

Problems with indexes, try the following:

Force an "update statistics" (this should happend automatically in MSSQL 7 and up).
Update Stats on one table:
USE DEV
UPDATE STATISTICS bsas

Update Stats on all tables:
USE DEV
EXEC sp_updatestats

Refreshing the statistics force the Stored Procedures to be recompiled again and the execution plans to be updated. The following command should have similar effect:
EXEC sp_recompile bsas