sp_helpindex command gives the information of the indexes on the table

How do you know which index a table is using?

Question Posted / chandra rekha

Answer Posted / chandra rekha

sp_helpindex command gives the information of the indexes
on the table

Is This Answer Correct ?

10 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How many instances per computer are there in sql server 2000?

1057

How to disable triggers using "disable trigger"?

1048

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

916

What is buffer cash and log cache in sql server?

1112

What are the kinds of subquery?

1006

What do you do in data exploration

983

What is the osql utility?

950

Explain how to integrate the ssrs reports in application?

1006

What is nonclustered index with included columns ?

960

What are the types of processing and explain each? : sql server analysis services, ssas

1144

Is it safe to delete log files?

908

What is data compression? : sql server database administration

964

What are examples of triggers?

1081

What is sleeping status in sql server?

1018

What are the new security features added in sql server 2012? : sql server security

1015