Skip to main content
BOB 2019

Logo of BOB 2019 BOB 2019

22nd March 2019

Berlin, Germany

Part of the BOB series

Superficial SQL Indexing

An Epidemic Plague

What if a single root cause was responsible for most SQL performance issues?

Proper indexing is a very time and cost-effective way to improve SQL performance. Yet hardly anyone gets it right so that about 50% of all SQL performance problems can be attributed to the index/query mismatch.

In this tutorial I’ll explain how organisational structures hinder proper indexing and why it is not sufficiently covered in the relevant literature. Naturally, this tutorial will also explain how to approach indexing for a better result and demonstrate the most common indexing mistakes in a fun and educating way: in a live quiz with the audience.

This session is held on in Tutorials #1