Blog Post

What Indexes are on My Table!

,

In this quick blog, I want to show you one way of how to find out what indexes you have on a table using SQL Server Management Studio (SSMS). When you have SSMS running and are connected to the database engine, navigate down the database hierarchy to the Tables folder. You should see the tables that you have access to within that particular database. If you expand on a table you should see a subfolder called Indexes. Expand Indexes and there you will find your indexes for that table. For this blog, I am looking at a local instance of the ReportServer database. As you can see by the below screenshot the ExecutionLogStorage table has two indexes. One primary key CLUSTERED index and another NON-CLUSTERED - Non Unique index.

 

Tree  

 

If you double click the index, you may see something like shown below.

 

Index Properties 

 

 

In order to keep this a quick blog, I’m not going to go into all the details about indexing. That could take up an entire chapter (actually probably many chapters) in a book. Come to think about it, there are books that were solely written about indexing and performance tuning. At any rate, I hope you learned something in this quick blog post.

 

Until next time, “keep your ear to the grindstone” – Good Will Hunting

 

 

Brian K. McDonald, MCDBA, MCSD
Business Intelligence Consultant – Pragmatic Works Consulting

Email: bmcdonald@pragmaticworks.com | Blog: BI Developer Network

Convert with DTS xChange  | Develop with BI xPress  | Process with TaskFactory | Document with BI Documenter

 

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating