Hi,
is it possible disable index optimization? I would like to perform SQL
queries just like they were written without any change.
select *
from A right join B on B.column1=A.column1
where A.column2 = someconditonX and B.column2 = someconditionY
I would like to searching on A with the
A.column2 = someconditonX
then on table B with:
B.column1 = A.column1 and B.comlumn2 = someconditonY
but actually the plugin searches for:
B.column2 = someconditon Y and ignores the (right) join: B.column1=A.column1
Thanks,
Pablo.
PS: if diabling optimization is not possible any help to understand how
outer join cost is calculated would be very much appreciated.
--
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.
