I'm just looking at the created indexes and getting with SELECT sql, index_class FROM information_schema.indexes WHERE table_name = 'USER' AND primary_key = FALSE
this result SQL <http://localhost:8082/query.do?jsessionid=4543ce724e0a897791e57bfcdcc8807b#> INDEX_CLASS <http://localhost:8082/query.do?jsessionid=4543ce724e0a897791e57bfcdcc8807b#>CREATE UNIQUE HASH INDEX PUBLIC.USER_IDX_0 ON PUBLIC.USER(EMAIL) org.h2.index.PageBtreeIndex It puzzles me that the PageBtreeIndex gets used for both the normal and hash indexes. It's a single column index and the column is Nullable Unicode VARCHAR(255). Regards, Martin. -- 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. For more options, visit https://groups.google.com/d/optout.
