How can I enforce to use particular index?

Question Posted / saravakumar

How can I enforce to use particular index? ..

Answer / saravakumar

You can use index hint (index=index_name) after the table
name. SELECT au_lname FROM authors (index=aunmind)

Is This Answer Correct ?

7 Yes

0 No

More SQL Server Interview Questions

How get current date in SQL server 2000

What are the options which must be set to allow the usage of optimistic models?

What is your recommendation for a query running very slow? : sql server database administration

Explain timestamp datatype?

What is difference between process and thread? Explain lazy writer funcationality.

What is the difference between insensitive and scroll cursor?

How you can get the list of largest tables in a database?

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

What is a field name?

Why truncate is ddl?

Explain syntax for viewing, dropping and disabling triggers?

For more SQL Server Interview Questions Click Here