SQL Indexing and Tuning e-Book


A site explaining SQL indexing to developers—no crap about administration.

SQL indexing is the most effective tuning method—yet it is often neglected during development. Use The Index, Luke explains SQL indexing from grounds up and doesn't stop at ORM tools like Hibernate.

Use The Index, Luke is the free web-edition of SQL Performance Explained. If you like this site, consider getting the book. Also have a look at the shop for other cool stuff that supports this site.

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

Use The Index, Luke presents indexing in a vendor agnostic fashion. Product specific notes are provided like here:

DB2

Use The Index, Luke covers SQL indexing for IBM DB2. Tests were conducted with DB2 for Linux, UNIX and Windows, (LWU) V10.5 Express-C.

MySQL

Use The Index, Luke covers SQL indexing for MySQL. Tests were conducted with MySQL 5.5 and 5.6.

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 and 9.2.

SQL Server

Use The Index, Luke covers SQL indexing for Microsoft SQL Server. Tests were conducted with SQL Server 2008R2 and 2012. Updates for 2014 are currently added..

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

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. Of course, you can also hire me for consultancy or training.

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

Photo of Markus Winand
Markus Winand tunes developers for high SQL performance. He also published the book SQL Performance Explained and offers in-house training as well as remote coaching at http://winand.at/

?Recent questions at
Ask.Use-The-Index-Luke.com

1
vote
2
answers
5.3k
views

"Order by RAND()" - can use Index?

Feb 23 at 12:06 Markus Winand ♦♦ 936
random index mysql order-by-rand
0
votes
2
answers
1.1k
views

index for better performance for a merge operation

Feb 20 at 11:43 antilet 1
merge index
0
votes
0
answers
2.0k
views

Join with inequalities only

Dec 16 '14 at 12:06 Markus Winand ♦♦ 936
inequality join