Re: SQL: Index hints

2017-04-21 Thread Sergi Vladykin
Exactly, this syntax was taken from MySQL. Sergi 2017-04-21 9:58 GMT+03:00 Denis Magda : > If multiple indexes are listed then H2 will pick only one of them like > MySql does, right? > > Denis > > On Thursday, April 20, 2017, Sergi Vladykin >

Re: SQL: Index hints

2017-04-21 Thread Sergi Vladykin
No, it must be USE INDEX without underscore. Also mention that multiple indexes can be listed. http://h2database.com/html/grammar.html#table_expression Sergi 2017-04-21 4:25 GMT+03:00 Denis Magda : > Sergi, I’ve documented this feature for 2.0. Please confirm that the text

Re: SQL: Index hints

2017-04-20 Thread Denis Magda
Sergi, I’ve documented this feature for 2.0. Please confirm that the text below is technically correct: Index hints are useful in scenarios when it's known that one index is more selective for certain queries than another and it's needed to instruct the query optimizer to choose a more

Re: SQL: Index hints

2017-01-23 Thread Denis Magda
Created a ticket so that we don’t forget about this new H2 capability. https://issues.apache.org/jira/browse/IGNITE-4594 Alexander P. feel free to assign it on yourself. — Denis > On Jan 23, 2017, at 10:05 AM, Dmitriy Setrakyan

Re: SQL: Index hints

2017-01-23 Thread Dmitriy Setrakyan
Very cool! Would be nice to add it to Ignite. On Mon, Jan 23, 2017 at 3:17 AM, Sergi Vladykin wrote: > 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)