[thelist] SQL Index Optimization

Joshua Olson joshua at waetech.com
Tue Oct 22 18:47:01 CDT 2002


----- Original Message -----
From: "Colin Mitchell" <colspan at jerkvision.com>
Sent: Tuesday, October 22, 2002 2:48 PM


> > SELECT field1, field2, field3
> >   FROM areas
> >   WHERE latitude BETWEEN 38.3978237603 AND 39.2662562397
> >     AND longitude BETWEEN 76.5625489108 AND 77.6773710892
> >   ORDER BY field1
> >
> > I only noticed a marginal speed improvement?
> >
>
> perhaps add an index to field1 also?

Yes, I did that.


-joshua




More information about the thelist mailing list