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 do you connect 100 files as a flat file sources in one package of SSIS?

Does sql server use t sql?

Explain subquery and state its properties?

What are difference between Cluster index and Non-Cluster index?

Tell me what is use of except clause? How it differs from not in clause?

what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration

difference between Clustered index and non clustered index ?

If we shrink the Databse and Files, how much size is decreased?

Can we call future method from trigger?

What is update_statistics command?

How to automatically create a log when an exception is being received into SQL Server?

Do you know hot add cpu in sql server 2008?

For more SQL Server Interview Questions Click Here