Re: ORDER BY, LIMIT and indexes

[Michael Paquier <michael.paquier@xxxxxxxxx>]

On Tue, Aug 6, 2013 at 8:25 AM, Claudio Freire <klaussfreire@xxxxxxxxx> wrote:

On Mon, Aug 5, 2013 at 8:04 PM, Ivan Voras <ivoras@xxxxxxxxxxx> wrote:
> SELECT * FROM table ORDER BY id DESC LIMIT 10 OFFSET 10
>
> SELECT * FROM table WHERE active ORDER BY id DESC LIMIT 10 OFFSET 10

Did you try explain?

And did you run ANALYZE on your table to be sure that you generate correct plans?

--
Michael