SQL Indexing and Tuning e-Book

A tutorial covering SQL indexing and SQL tuning for developers: avoiding unnecessary details about database internals.

SQL indexing is the most effective SQL tuning method and requires the same care as schema design yet it is often neglected during development. Use The Index, Luke explains SQL indexing from the source code perspective—covering ORM tools like Hibernate and Doctrine.

SQL Indexing in MySQL, Oracle, SQL Server, etc.

SQL Indexing is presented as a vendor independent topic. To improve the reading experience, the main body of the book uses only the Oracle terms only. Product specific notes are provided as shown below.

It's a living book—make sure to follow via RSS, Twitter or Facebook.

Have more questions about SQL indexing or tuning? No problem—the Ask.Use-The-Index-Luke.com forum is the right place to discuss them.

Use The Index, Luke is a free tutorial and is provided under the Creative Commons license. Reading online is possible on any web-enabled device—and you can also buy the print or PDF editions.

Table of ContentsStart Reading

Training and Coaching Buy Book