SELECT (Level 3)
|SQL Server 6.x||SQL Server 2000|
|The FASTFIRSTROW optimizer hint caused the optimizer to use the nonclustered index if one matches the ORDER BY clause.||The OPTION (FAST n) query hint replaces FASTFIRSTROW. However, FASTFIRSTROW is maintained for backward compatibility only.
Consider removing all references to FASTFIRSTROW in SELECT statements and replacing with references to OPTION (FAST n).
|The INDEX = syntax specified one or more indexes to use for a table hint.||Supported for backward compatibility only.
Consider removing all references to INDEX = and replacing (when using multiple index hints) with references to INDEX(index, index...) as shown in SELECT.