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 h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
