What every developer should know about SQL performance
Preface — Why is indexing a development task?
Anatomy of an Index — What does an index look like?
The Where Clause — Indexing to improve search performance
The Equals Operator — Exact key lookup
Functions — Using functions in the where clause
Bind Variables — For security and performance
Searching for Ranges — Beyond equality
Partial Indexes — Indexing selected rows
NULLin the Oracle Database — An important curiosity
Obfuscated Conditions — Common anti-patterns
Testing and Scalability — About hardware
The Join Operation — Not slow, if done right
Clustering Data — To reduce IO
Sorting and Grouping — Pipelined order by: the third power
Partial Results — Paging efficiently
Insert, Delete and Update — Indexing impacts on DML statements
Databases course that wasn't as useful as this book.'