At 12:11 PM 6/1/00 -0500, Ed Loehr wrote:
>Jerry Lynde wrote:
> >
> > As for the query I'm running, it was simply select * from
> bigtable (about
> > 2-300k lines) where
> > firstname=<obscure
> fname> and
> > lastname=<obscure
> lname> and
> > DOB=<the exact DOB for
> the above named individual>
>
>What indices do you have on those fields?
>
>Regards,
>Ed Loehr
They are all indexed, the DOB index is actually DOBYear DOBDay and
DOBMonth and all 5 fields are indexed