Re: [PERFORM] Using LIMIT changes index used by planner

Thu, 23 Dec 2004 18:15:31 -0800 

On Mon, 13 Dec 2004 17:43:07 -0500, Tom Lane <[EMAIL PROTECTED]> wrote:

Sven Willenberger <[EMAIL PROTECTED]> 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 ?

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Reply via email to