Re: The old "not using index" question

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