Is there anything equivalent available in SQL Server for Oracle HINTS ?
eg : Oracle query
select /* + INdex(sno index1) */ sno from test_table
Thanks,
SamYes they are also called "HINTS". Please look at SQLServer Help text (Query Analyzer -> Help) and search on "HINTS" which has details that you need.
Vinnie|||And you're better off not using them unless the box is on fire...
MOO
Showing posts with label index1. Show all posts
Showing posts with label index1. Show all posts
Monday, March 26, 2012
Subscribe to:
Posts (Atom)