Hi Noel, Thank you for the clarification provided.
Previously, the job took ~15min for ALTER ADD Column. But after the below changes in JDBC URL, I see the ALTER job got completed in 10mins. CACHE_SIZE=2097152;LOG=0;LOCK_MODE=0;UNDO_LOG=0 I just need clarification reg ALTER Statement in h2 Database. Is that ALTER ADD Column will insert / write *"null"* into all the records after adding the new column. So only it is taking long time to complete the task. *Regards*, Prasad On Thursday, June 15, 2017 at 11:55:22 PM UTC+5:30, Noel Grandin wrote: > > Have a look at the options at the bottom of this document: > > http://h2database.com/html/performance.html > > Note that you should only use them while doing your ALTER TABLE and > nothing else should be touching your DB when you do it, and you should have > backups in case anything goes wrong > -- 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 https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
