On Saturday, September 24, 2011 5:16:02 AM UTC-6, kensystem wrote: > > explain analyze SELECT COUNT(*) FROM om WHERE objvalue='468203' AND > (OMATTRIBID=26 OR OMATTRIBID=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%) */ > > Hi Thomas, I hope my description was clear enough that you can verify this is a problem(?) Is there a patch I can test?
Thanks in advance, ken -- 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/-/QfyLWLAXNsUJ. 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.
