SQL SERVER - Detecting non-indexed columns but used in WHERE clause
- by Vadi
How to detect a column included in WHERE clause but used in indexed?
Little Background:
Until the time the table has few number of records things will be okay, once it started having millions of records then index should be created for a column which is used in WHERE clauses in stored procs, inline queries etc.,
Since we have hundreds of stored procs and queries that often gets changed by the devs I wanted to have a automated way of identifying those columns that are used in WHERE clauses but not an index is created. How to do that in SQL SERVER 2008?