On Fri, Nov 29, 2002 at 05:37:04PM +0100, Jan-Philipp 'Thefly' Reining wrote:
> ---but this one does not?
> SELECT *
> FROM ttm_slots s
> WHERE s.peering = 72
> AND s.ranking < 1050
> AND s.ranking > 950
>
> The index ist "btree", so it should be able to use the index with a < >
> comparison?
show us explain analyze output.
probably planner thinks there are too many rows matching this criteria
to use index.
depesz
--
hubert depesz lubaczewski http://www.depesz.pl/
------------------------------------------------------------------------
Mój Boże, spraw abym milczał, dopóki się nie upewnię, że naprawdę mam
coś do powiedzenia. (c) 1998 depesz