Joshua Paling

Talk on database indexing

Great talk on database indexing

Key points:

• In a multi-column index, order matters
• All but the final column of an index can only work on exact match
• Range indexes only work on the final column of an index