>From the documentation: "If the query condition does not contain the row id (and if no other index can be used), then all rows of the table are scanned." I guess that is a major important information when you trying to optimize your SQL, so it should be stated more visible and clearly. I am used to DB2/Oracle that performs this optimization, so I just took it for granted :)
H2 performance is really quite excellent, you just have to know to use the UNION optimization sometimes. Thomas. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to h2-database@googlegroups.com. To unsubscribe from this group, send email to h2-database+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.