Hi,

Sometimes the execution order of tables can vary a lot by add-in a simple 
condition.

select * from
tableA a
INNER JOIN
tableB  b on b.id=a.id
WHERE
..

depending on the where conditions tableA is invoked first or not.

How to force H2 to use tableA prior tableB always?

Thanks!
Pablo.


-- 
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 http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

Reply via email to