Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

Write a program using SQL queries to find a unique entry in a table.

0 Answers   Tech Mahindra,


Explain encryption of entire databases without the need for application changes in sql server 2008?

0 Answers  


Why truncate is ddl?

0 Answers  


What is function of CUBE ?

0 Answers   HCL,


What is not null constraint?

0 Answers  


In clustered and non clustered indexes which one is faster while executing a query ?

1 Answers  


What is clr ddl trigger?

0 Answers  


What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   HCL,


What are three major types of constraints?

0 Answers  


Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

0 Answers  


What is Sqlpaging in SqlServer 2005 ?

0 Answers   MCN Solutions,


How ssrs maintain security?

0 Answers  


Categories