Hi Adam,
I mean query is very slow. Explain plan looks good and it is using index. I
did not compare with other databases.
Thanks.
--
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
Hi,
I have created a simple join query between two tables and performance is
very bad.
I read the documentation and understand that query optimizer have some
limitations. i would like to go thorough them before actually posting the
my query having the issues.
Could you please point me to the
Hi,
I am using h2 1.4.191 version.
I have created Person table with indexes on id and name.
*select * from Person p where p.id in ('1', '3') OR name in ('name0',
'name1') order by id *is not using indexes.
As IN query does not use index, i have written the above query -
*select * from (*
*