Horton

Re: Using LIMIT changes index used by planner

PFC <lists@boutiquenumerique.com>

View thread
From: Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
To: pgsql-performance@postgresql.org
Date: 2004-12-24T02:05:59Z
Lists: pgsql-performance 
On Mon, 13 Dec 2004 17:43:07 -0500, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Sven Willenberger <sven@dmv.com> writes:
>> explain analyze select storelocation,order_number from custacct where
>> referrer = 1365  and orderdate between '2004-12-07' and '2004-12-07
>> 12:00:00' order by custacctid limit 10;

	why not create an index on referrer, orderdate ?