You could try using an index like this:
SELECT * FROM VSSQ_USER LIMIT 10 OFFSET 600000 ORDER BY ID__
But even that is not going to be particularly fast because it will still
have to iterate through the whole index to find the right position.
The correct answer is "don't do that".
Why on earth on would you be trying to do that anyhow?
On 2013-07-11 10:33, pittlu wrote:
There is a table named vssq_user contains 1,000,000 records,the
following SQL query takes more than 20 seconds:
SELECT * FROM VSSQ_USER LIMIT 10 OFFSET 600000
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
