Guys, Recently in H2 we've merged a very important feature: index hints. It is an additional MySQL-like syntax:
SELECT * FROM my_table USE INDEX (index_a) WHERE A = 1 It will be very easy to support this in Ignite. Alex, Since you are working on better SQL Enum support and it will require H2 upgrade anyways, you can add this stuff to Ignite as well. Sergi
