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.

Use The Index, Luke! is actually a real book: it's the online edition of SQL Performance Explained. If you like this site, you should consider buying the book (starting from €9.95) to support our work on this site.

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 the Oracle terms only. Product specific notes are provided as shown below.

DB2

Use The Index, Luke covers SQL indexing for IBM DB2. Tests were conducted with DB2 for Linux, UNIX and Windows, V9.7.

MySQL

Use The Index, Luke covers SQL indexing for MySQL. Tests were conducted with MySQL 5.1.

Oracle

Use The Index, Luke covers SQL indexing for the Oracle database. Tests were conducted with Oracle 11r2. 12c updates are currently added.

PostgreSQL

Use The Index, Luke covers SQL indexing for PostgreSQL. Tests were conducted with PostgreSQL 9.0.

SQL Server

Use The Index, Luke covers SQL indexing for Microsoft SQL Server. Tests were conducted with SQL Server 2008R2.

A full book, covering all major SQL databases is not yet cool enough? So check out these little links that appear next to the execution plans shown in the book: Try online at SQL Fiddle. Click on it to try the shown examples online at SQL Fiddle!

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.

About the Author

As an author, trainer, and coach Markus Winand specializes in helping developers cope with SQL performance issues. He also published the book SQL Performance Explained and tweets his best performance tips via @SQLPerfTips.http://winand.at/

Recent Questions at Ask.Use-The-Index-Luke.com

0
votes
1
answer
146
views

We want to buy the book but I can't

Jul 18 at 21:36 Markus Winand ♦♦ 541
book
0
votes
2
answers
159
views
0
votes
0
answers
821
views

Performance very bad in Postgresql 9.3

Jul 08 at 11:54 Markus Winand ♦♦ 541
performance issue