> Generally you want '=' conditions on the leftmost index keys; any
> inequality or range constraint should be on the rightmost
> keys. You can see this by thinking about the range of index entries that
> the scan will have to pass over.
I see. Just like in your earlier example, where you reduced the number of
index entries to pass over by giving the stockid, productid and the changeid
Thank you very much.
-- Csaba Együd
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.712 / Virus Database: 468 - Release Date: 2004. 06. 27.
In response to
pgsql-general by date
|Next:||From: Soeren Gerlach||Date: 2004-06-30 06:26:57|
|Subject: Slow dump with pg_dump/pg_restore ? How to improve ?|
|Previous:||From: Joe Conway||Date: 2004-06-30 05:26:07|
|Subject: Re: minimum operators for b-tree, r-tree|