Hello. Queries like SELECT * FROM SOME_TABLE WHERE COUNTRY = something AND STATE = something and similar will be able to use a normal multi-column index if *first* columns of this index are COUNTRY and STATE. There is no reason for additional weird indexed computed combined column, such column will only increase size of you database.
-- 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 view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/65392491-fe87-4b19-9067-c3c688dfc118%40googlegroups.com.
