Indexing the SQL Database

*

Excerpt

Most developers find they have to use SQL databases for their projects, but few have any idea how to index those databases. Which columns to index, what kinds of indexes to use, multicolumn indexes, foreign keys ... it's all very confusing to anyone who's not a career database person (and even some that are).

Description

Most developers find they have to use SQL databases for their projects, but few have any idea how to index those databases. Which columns to index, what kinds of indexes to use, multicolumn indexes, foreign keys … it’s all very confusing to anyone who’s not a career database person (and even some that are).

Josh Berkus, PostgreSQL Project Core Team, will cover:

- Assorted Types of Indexes
-
The Three Methods of Indexing your Database
- The Four Reasons to Index a column or table
-
How to think about Multicolumn Indexes

Given that this is a 45-minute session, specialty index types will be mentioned, but not detailed.

Speaking experience

Speaker