Well, we discussed this during SQL YouTube Live – Performance Troubles – Execution Plans. Let us see MAX Column ID Used in Table.
The challenge I face is that often DBAs ask me to prove that indexes are really not used by queries. Let us learn about Queries Using Specific Index.
One of the most popular questions I received during my Comprehensive Database Performance Health Check is Finding Queries Using Particular Index.