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.
If you double click the index, you may see something like shown below.
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