Hi, > i run following command > ANALYZE SAMPLE_SIZE 0 > (356975 ms)
Just ANALYZE is enough in most cases, and it is much faster. > i have many DB having 2-3 million of records > its all one time insert and there can be small updates later on > major is selection > how do i fast my select queries > do i need to run "ANALYZE SAMPLE_SIZE 0" always after all insert No, usually only once. > how does it affect performance ???? It updates the selectivity statistics of all tables - see http://www.h2database.com/html/grammar.html#analyze Regards, Thomas --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
