Curriculum Director for IT Pro Content
SQL Server indexes are an absolutely crucial part of SQL Server performance - but do you know how they REALLY work? Like, under the hood? Index and PTO geek Don Jones takes you on a backstage tour of indexes. You'll learn about B-trees, clustered and non-clustered indexes (separating myth from fact), how indexes consume storage and become fragmented, and how - over time - index design MUST be revisited and revised on ANY database.
You will learn:
- Choose the right kind of index (there's more than two!)
- Learn WHY and HOW index maintenance becomes necessary
- Get hard numbers on index tuning and maintenance