Curriculum Director for IT Pro Content
Index and PTO geek Don Jones takes you on a backstage tour of indexes.
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