My client reached out to me asking if there is a way to measure the performance of the newly created index. How to measure index performance.
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.
Well, the answer is pretty straight forward and that is what we are going to see in today’s video of One Scan for 3 Count Sum.
Today we will take the same conversation to the next level by discussing Single Scan for 3 Operations – COUNT(*) COUNT(1) SUM(1).