How can I enforce to use particular index?

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

Post New Answer

More SQL Server Interview Questions

1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them?

1 Answers   Techno Solutions,

can i write function in stored procedure and stored procedure in function and nested procedure.Give one example for each question?

1 Answers   Cap Gemini, TCS,

What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)

1 Answers  

What are indexes? When do you need to create Indexes?

4 Answers   HP, CarrizalSoft Technologies,

What is the best way to move n number of DTS package from one SQLServer to another SQLServer?

1 Answers   RBS,

Explain Capacity planning to create a database? and how to monitor it?

0 Answers  

Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?

1 Answers  

How get current date in SQL server 2000

6 Answers   Cap Gemini,

last function used in MS Access to convert sql what function will use in sql

0 Answers   Cap Gemini,

user defined datatypes

1 Answers   Wipro,

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

2 Answers  

What is a Join in SQL Server?

3 Answers