Re: 2 column between optimization

[Felix Geerinckx]

Brad Culberson wrote:

> Select * from geo_feature where latitude BETWEEN
> .06494 and 0.7384 and longitude between -1.234 and
> -1.1212;
>
> also tried:
>
> Select * from geo_feature where latitude >
> .06494 and latitude < 0.7384 and longitude >
> -1.234 and longitude < -1.1212;

Could you also post the EXPLAINs for these queries?

--
felix
Please use BBCode to format your messages in this forum.