Mark, The ANALYZE is probably superfluous. By default, an ANALYZE is automatically performed after a total of 2000 rows are either added or removed. Then, subsequently after 4000 adds/removes, 8000, 16,000, etc... always doubling.
On Sep 8, 8:07 pm, Mark Addleman <[email protected]> wrote: > This is interesting. I have a pattern of many thousands of inserts while > periodically issuing a DELETE of around ~100,000 rows. Right now, I run an > ANALYZE after each DELETE operation. Is the ANALYZE superfluous? -- 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.
