We can be Rebuilding Index with Compression even if it was originally not created with compressions. Let us learn how we can do it today.
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).