I'm considering attempting to add index hints to H2.
Questions:
* Is this a good idea? Or is it better to work on making the query
optimizer smarter at choosing the correct index?
* Is Oracle's syntax preferable? Or MySQL's syntax? Or is there a better
syntax altogether?
Oracle:
SELECT /*+ INDEX (employees emp_department_ix)*/
employee_id, department_id
FROM employees
WHERE department_id > 50;
MySQL:
SELECT * FROM table1 USE INDEX (col1_index,col2_index)
WHERE col1=1 AND col2=2 AND col3=3;
--
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 https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
