Hi, I can reproduce the problem. It looks like H2 doesn't use an index because you are using a view instead of querying the table directly. I understand it's not nice, and I will try to solve this problem, but I can't promise when I will have time. My test case is:
drop view test_view; drop table test; create table test(a int, b int, primary key(a, b)); create view test_view as select * from test; insert into test select x, x from system_range(1, 10); -- using an index: explain select * from test where a in(1, 5); -- not using a index: explain select * from test_view where b in(1, 5); Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
