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 do you know which index a table is using?

Answer Posted / visala

sp_help <tablename>
sp_helpindex <tablename>

Is This Answer Correct ?    9 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is INSTEAD OF trigger directly applicable to Table ?

1009


How to write a query with a left outer join in ms sql server?

968


How does using a separate hard drive for several database objects improves performance right away?

923


What are pessimistic lock and optimistic lock?

1064


How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

1004


What are the components of sql server service broker?

1007


What is the syntax to execute the sys.dm_db_missing_index_details?

1016


How to handle error or exception in sql?

975


How to override dml statements with triggers?

1171


Explain something about security and SQL Azure?

134


What is the optimization being performed in oracle and SQL Server?

1044


What is the difference between delete and truncate statements?

1065


You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

1027


What is faster join or union?

1193


Define left outer join?

958