[thelist] SQL Index Optimization

Colin Mitchell colspan at jerkvision.com
Tue Oct 22 13:49:01 CDT 2002


> 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?

colin






More information about the thelist mailing list