Which Index SELECT COUNT(*) will use?

Resources mentioned in this blog:
Health Check: [ Ссылка ]
Script: [ Ссылка ]
Video: [ Ссылка ]

Subscribe for Free Performance Tuning Scripts: [ Ссылка ]

0:00 Intro
0:19 What would you like to see next?
0:29 Real World Scenario
0:49 Demo: COUNT(*) and Index
2:28 An Interesting Tip
2:40 Check this Video (Fastest Way to Retrieve Rowcount for a Table)
2:51 Summary

#SQLServer #PerformanceTuning #SQLAuthority

свернуть