Joy of Index

*

Excerpt

Every SQL database needs indexes, but which indexes? Learn how to index, when to index, why to index, and how to feel after you've indexed.

Description

Every SQL database needs indexes, but which indexes? Learn how to index, when to index, why to index, and how to feel after you’ve indexed.

In 40 minutes, you will learn a set of basic principles which will help you decide how to index your databases which apply to almost any SQL database. You will also discover the PostgreSQL tools which allow you to check if you’ve indexed correctly on that DBMS.

Speaking experience

Speaker

  • Headshot

    Josh Berkus

    PostgreSQL Project

    Biography

    Josh Berkus is best known as a Core Team member of the world-spanning PostgreSQL project. He is CEO of PostgreSQL Experts, Inc. and in his 12 years as a database consultant he has worked with CouchDB, MySQL, Oracle, and MSSQL Server as well as Postgres, and is heavily involved in many OSS communities, including BIRT, OSCON, OSfA, Noisebridge and more. He’s also a potter and a mean cook.

    Sessions