Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Yet Another newbie not understanding why an index isn't used - Mailing list pgsql-general

From Michal Maru¹ka
Subject Re: [GENERAL] Yet Another newbie not understanding why an index isn't used
Date
Msg-id 199907050231.EAA09411@linux3.maruska.tin.it
Whole thread Raw
In response to Yet Another newbie not understanding why an index isn't used  (Felix Morley Finch <felix@crowfix.com>)
List pgsql-general
Tree view 
> hlt=> EXPLAIN SELECT * FROM hltdata ORDER BY stmp, id LIMIT 10;


If I remember well, the order of the index attributes must be the same as
... in the query which should use it: try "id, stmp"

pgsql-general by date:

Previous
From: Leon
Date:
Subject: Re[4]: [GENERAL] Joins and links
Next
From: Bruce Momjian
Date:
Subject: Re: Fw: Re[2]: [GENERAL] Joins and links