Yves Vindevogel wrote:
> Hi, 
> 
> rvponp=# explain select * from tblprintjobs order by loginuser,
> desceventdate, desceventtime offset 25 limit 25 ;
>
> I have a very simple query on a big table.  When I issue a "limit"
> and/or "offset" clause, the query is not using the index. 
> Can anyone explain me this ? 

Do you have an index on (loginuser,desceventdate,desceventtime)?

-- 
_______________________________

This e-mail may be privileged and/or confidential, and the sender does
not waive any related rights and obligations. Any distribution, use or
copying of this e-mail or the information it contains by other than an
intended recipient is unauthorized. If you received this e-mail in
error, please advise me (by return e-mail or otherwise) immediately.
_______________________________

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to