On Monday 12 January 2009, "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> wrote:
> I've found that when you do frequently query on two or more columns, a
> multi-column index is faster than bitmap scans, especially for larger
> data sets.
Very much faster, especially if you're only looking for a few dozen or
hundred rows out of multi-million row tables.
--
Current Peeve: The mindset that the Internet is some sort of school for
novice sysadmins and that everyone -not- doing stupid dangerous things
should act like patient teachers with the ones who are. -- Bill Cole, NANAE