- August 12–22: Online Training (EU shift)
- FOSDEM Impressions
- June 8–18: Online Training (US shift)
- Non-monetary micro sponsoring
- November 11-12 in Frankfurt am Main
- Online-Training in July and August
- Oracle + PostgreSQL
- Party time
- PostgreSQL Performance Event
- SQL Server Performance Kurs in Stuttgart
- SQL Server performance training in London
- Shipping Terms
- The two top performance problems caused by ORM tools
- Top Tweets January 2013
- Training Survey
- Training and Conference Dates
- Use The Index, Luke
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.
Use The Index, Luke covers SQL indexing for IBM DB2. Tests were conducted with DB2 for Linux, UNIX and Windows, V9.7.
Use The Index, Luke covers SQL indexing for MySQL. Tests were conducted with MySQL 5.1.
Use The Index, Luke covers SQL indexing for the Oracle database. Tests were conducted with Oracle 11r2.
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.
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.