efmarshall / h2database

Automatically exported from code.google.com/p/h2database
0 stars 0 forks source link

Support USE INDEX hint #544

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
Some statements hint to the optimizer to consider another query plan.  MySQL 
implements this with USE INDEX:

http://dev.mysql.com/doc/refman/5.6/en/index-hints.html

I would like to add support to this for H2, which will ignore this hint 
initially.

Original issue reported on code.google.com by g...@maginatics.com on 24 Jan 2014 at 10:17

GoogleCodeExporter commented 9 years ago
Can we also add support for FORCE INDEX syntax (Mysql docs have more info)

Original comment by leoamig...@gmail.com on 7 Mar 2014 at 1:04