title: H2 database: clustered indexes support
body: <p>I use H2 database for environmental data which contains lots of time series. Time series are simply measurement values of sensors which are recorded in database periodically (say once per hour). </p>
  
  <p>The data stored in the table:</p>
  
  <pre><code>CREATE TABLE hydr
  (dt timestamp
  ,value double
  ,sensorid int)
  </code></pre>
  
  <p>I would like to make range queries against the table, for example: </p>
  
  <pre><code>select * from hydr
  where dt between '2010-01-01' and '2010-10-01'
  </code></pre>
  
  <p>In order to improve performance I would like to build clustered index over dt column, but the thing is, that I haven't found if H2 supports clustered indexes. Does anybody know if <em>clustered indexes</em> are supported in H2?   </p>