[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