Re: Why the difference in plans ?

Dave,

> Below I have two almost identical queries.  Strangely enough the one
> that uses the index is slower ???

My first guess would be that records are highly correlated by DOB and not at
all by name.  However, it would help if you supplied both the index
definitions and what changed between the two queries to cause the index to be
used.

--
Josh Berkus
PostgreSQL @ Sun
San Francisco