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

What is Left Outer Join?

2 Answers  

how can i lock the column in the table

2 Answers   Accenture,

What is INTVAL( )and where we use Plz any body help me

1 Answers  

does physical index sort data

1 Answers  

What is the basic difference between clustered and a non-clustered index?

9 Answers  

What are the different ways of moving data/databases between servers and databases in SQL Server?

1 Answers  

What are the differences between UNION and JOINS?

3 Answers   CarrizalSoft Technologies,

How can u get the number of pupils connecting the database?

1 Answers   Cap Gemini,

What is Deadlock?

4 Answers   Satyam,

If a stored procedure is taking a table data type, how it looks?

1 Answers  

Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.

1 Answers  

i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..

4 Answers