Indexing Deep Dive for Beginners [DBA]
Duration: 2.5 hours
To a beginner, indexes may seem like magic. The right index can drastically reduce query time. But, how do you know which indexes are the right ones? SQL Server will suggest helpful indexes in the graphical execution plan and with the Database Engine Tuning Advisor, but follow that advice with caution. This session will explain how indexes work and how to tune and maintain indexes so that your application has the best performance.