Thomas, I'm sorry, this statement only ran slow due to disk (caching a large resultset): SELECT * FROM om WHERE OMATTRIBID IN (26,27) Using COUNT it runs fast (<1 second) SELECT COUNT(*) FROM om WHERE OMATTRIBID IN (26,27)
Even so the compound criteria still runs slow (with COUNT(), and it only should return 1 row anyway :-) SELECT * FROM om WHERE OMATTRIBID=26 AND objvalue='468203' (few milliseconds) SELECT * FROM om WHERE OMATTRIBID IN (26,27) AND objvalue='468203' (60 seconds) -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/kf6dtOtHIqgJ. 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.
