Stab in the dark, but maybe analyze with a larger sample size?
ANALYZE SAMPLE_SIZE 1000
Sorry, thomas and noel are much more experienced than me :)
On 11/07/2012 4:29 PM, Bartosz Skorupa wrote:
Yes, and for one query it is faster, but when i change numbers in
WHERE it come back to long performance time.
Pozdrawiam
Bartosz Skorupa
2012/7/11 Thomas Mueller <[email protected]
<mailto:[email protected]>>
Did you run "analyze"?
--
You received this message because you are subscribed to the Google
Groups "H2 Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
