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


Reply via email to