Hi, I have a table test with two columns key1 and key2. There are index on both columns and explain plan shows that the indexes are used for the queries
- select * from test where key1 = 'x' - select * from test where key2 = 'y' However, If I have a query like - select * from test where key1 = 'x' or key2 = 'y' a table scan is done and the indexes are not used. I searched in the documentation and it seems that hints are (not yet) supported. Is there another way to force the database to use the indexes? For this simple example, I could use UNION ALL but this makes query statements quite complex. At least explain plan shows the usage of the indexes, but I'm not sure whether this would perform well in any case. Is there any approach you can propose? 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.
