How do you know which index a table is using?

Answer Posted / chandra rekha

sp_helpindex command gives the information of the indexes
on the table

Is This Answer Correct ?    10 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

1737


How to change the name of a database user?

732


How many columns can exist together per table?

884


What is failover clustering overview?

759


What are subqueries in sql server?

790






How to see the event list of an existing trigger using sys.trigger_events?

768


what is a schema in sql server 2005? : Sql server database administration

692


What is the new security features added in sql server 2016? : sql server security

790


Explain four layers of abstraction microsoft architectured?

138


What are the disadvantages of using the stored procedures?

701


How do I create a stored procedure in dbml?

687


Explain what are the events recorded in a transaction log?

731


Where is localdb stored?

730


How can I create a report based on a query? : sql server management studio

758


In which format does an image save in SQL Server database ?

781