On Mon, Aug 5, 2013 at 8:04 PM, Ivan Voras <ivoras(at)freebsd(dot)org> 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?