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  






Categories