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 IDE,DMV in sql server?

1 Answers   Value Labs,

What's the difference between a primary key and a unique key?

4 Answers  

how to find the second salary?

10 Answers   HCL, Prithvi,

How can u convert the Date to String?

6 Answers   TCS, Microsoft,

Explain Trigger with an example?

2 Answers  

How to select nth record from a table?

13 Answers   Ramco, Microsoft, DELL,

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

0 Answers  

I have Two table First have UserName and second is address, in address table more than value relegated to UserName table, i want to fetch 2nd address if exist other wise 1st address access

4 Answers  

What is a trigger?

4 Answers  

how we can use a database with php.

2 Answers   HCL, IT Solution,

What is trigger ?

7 Answers   Cap Gemini, SQL,

Which system tables contain information on privileges granted and privileges obtained

1 Answers