I am storing timestamps within my records. Most of my queries will involve selecting from a range of time.
> It depends on what exactly you mean with clustered index... >From what I understand, a non-clustered index will store a key-value mapping outside of the database where the keys are ordered and the values are locations of records. A clustered index will actually store records in sorted order within the database itself, or so I think. > Could you explain what you need and why? Because there is an index file w/ H2, I will assume that some type of non-clustered indexing is done - correct me if I'm wrong because as you can see I'm no database expert. If there is a clustered indexing scheme, I'd like to test that to see if I get any performance benefit. It would also help me limit my disk i/o (which is severely limited) if I don't also have to write to an index. Hopefully I'm asking a reasonable question. Julian On Oct 21, 12:33 pm, "Thomas Mueller" <[EMAIL PROTECTED]> wrote: > Hi, > > > Is a clustered index supported? > > It depends on what exactly you mean with clustered index... Could you > explain what you need and why? > > 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 -~----------~----~----~----~------~----~------~--~---
