SQL Indexing and Tuning e-Book
A free tutorial to SQL indexing and SQL tuning for developers: It avoids 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 neglected during development. Use The Index, Luke explains SQL indexing from the source code perspective—covering ORM tools like Hibernate or Doctrine.
SQL Indexing in MySQL, Oracle, SQL Server,…
SQL Indexing is a vendor independent topic. The main body of the book uses the Oracle terms only—for a better reading experience. Product specific notes are provided like 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.
- 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.
It's a living book—make sure to follow via RSS, twitter or Facebook.
Having more questions on SQL indexing or tuning? No problem—the Ask.Use-The-Index-Luke.com forum is the right place to raise them.
Use The Index, Luke is a free tutorial as in the Creative Commons license. Online reading works on any web-enabled (mobile) device—but you can also download the e-book edition.
share and subscribe
RSS FeedFlattr this! Follow me on TwitterShare at Google+Like on Facebook