Hi, > In-memory indexes are automatically used for in-memory databases
That should mean: for in-memory databases, if you create an index, then the index is also kept in memory. But you still need to create the index. Indexes are not automatically created. Regards, Thomas On Fri, May 3, 2013 at 7:01 PM, neelima kaliki <[email protected]> wrote: > 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. > > > -- 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.
