News for hackers. Stuff that matters.
Re:Database development mistakes made by application developers by ams6110 on Monday December 13, 2010 @09:51AM (#2000595)
This is called a "covering" index, e.g. the index on lastname+firstname also "covers" queries on with a predicate on just the last name. Most relational databases will do this, but it's always good to be sure in your particular case.
Re:Database development mistakes made by application developers by morgo on Monday December 13, 2010 @10:18AM (#2000671)
It's a composite index. A covering index would be this:

ALTER TABLE staff ADD INDEX idx (last_name, first_name); SELECT first_name FROM staff WHERE last_name = 'n';

A covering index is something very special - all results are returned from the index. Not all databases do this - Postgres does not, because it does not want to maintain all the versions (see MVCC in wikipedia) in the index.

Re:Database development mistakes made by application developers by ams6110 on Monday December 13, 2010 @11:22AM (#2000925)
Indeed you are correct.