I'd forgotten that the info about scans is only done when EXPLAIN ANALYZE is used. Here is its output:
explain analyze SELECT COUNT(*) FROM om WHERE objvalue='468203' AND OMATTRIBID IN (26,27) SELECT COUNT(*) FROM PUBLIC.OM /* PUBLIC.OM_ATTRVAL_ID: OMATTRIBID IN(26, 27) AND OBJVALUE = '468203' */ /* scanCount: 2181921 */ WHERE (OMATTRIBID IN(26, 27)) AND (OBJVALUE = '468203') /* total: 34990 OM.OM_ATTRVAL_ID read: 34990 (100%) */ the same output was generated for: explain analyze SELECT COUNT(*) FROM om WHERE objvalue='468203' AND (OMATTRIBID=26 OR OMATTRIBID=27) So seem like my indexes (listed in earlier post) are not being used at all. -- 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/-/zKq4tluoaP8J. 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.
