I am using in-memory tables. Is indexes required in-memory tables as well? I read in documentation that indexes are automatically used for in-memory tables. Hence i have not created indexes. when i tried to create, i was getting OutOfMemroy exception with 8GB memory. But i have not tried creating indexes after upgrading to 16 GB memory. *"In-memory indexes are automatically used for in-memory databases, but can also be created for persistent databases using CREATE MEMORY TABLE. In many cases, the rows itself will also be kept in-memory. Please note this may cause memory problems for large tables. "* Please help me on the same. Thanks, Neelima.Kaliki
On Friday, May 3, 2013 12:47:16 PM UTC-4, Noel Grandin wrote: > If queries are running for a long time then you need to make sure you > have the right indexes for your queries. > -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
