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 ?
