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
- [GENERAL] Postmaster won't -HUP Jerry Lynde
- Re: [GENERAL] Postmaster won't -HUP Joseph Shraibman
- Re: [GENERAL] Postmaster won't -HUP Ed Loehr
- Re: [GENERAL] Postmaster won't -HUP Martijn van Oosterhout
- Re: [GENERAL] Postmaster won't -HUP Jerry Lynde
- Re: [GENERAL] Postmaster won't -HUP Joseph Shraibman
- Re: [GENERAL] Postmaster won't -HUP Jerry Lynde
- Re: [GENERAL] Postmaster won't -HU... Tom Lane
- Re: [GENERAL] Postmaster won'... Jerry Lynde
- Re: [GENERAL] Postmaster ... Tom Lane
- Re: [GENERAL] Postmaster won't -HUP Jerry Lynde