View Single Post

   
  #2 (permalink)  
Old 04-18-2008, 11:55 AM
Tom Lane
 
Posts: n/a
Default Re: Limit clause not using index

Yves Vindevogel <yves.vindevogel@implements.be> writes:
> create index ixPrintjobsLoginDescEventdateDesceventtime on
> tblPrintjobs (loginuser, desceventdate, desceventtime) ;


Hmm, that certainly looks like it should match the query. What happens
to the EXPLAIN output if you do "set enable_sort = false"?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply With Quote