Back to Indexes: The Original Culprit
Yes, indexes still remain the main bottleneck when it comes to performance, especially when your data grows big. In this demo-heavy session, Amit takes you through real-world scenarios of bad indexing designs and how they can be rectified to improve performance. Focus remains on clustered and non-clustered indexes and the esoteric combinations of them. If you think you know everything about indexes, think again!