And here part of a derby script that runs the queries twice: ij> -- Run 1 SELECT pk FROM t WHERE pk = 1; PK -------------------- 1
1 row selected ELAPSED TIME = 94 milliseconds ij> SELECT pk FROM t WHERE pk IN (1, 1000000); PK -------------------- 1 1000000 2 rows selected ELAPSED TIME = 16 milliseconds ij> SELECT pk FROM t WHERE pk = 1 OR pk = 1000000; PK -------------------- 1 1000000 2 rows selected ELAPSED TIME = 15 milliseconds ij> SELECT pk FROM t WHERE pk = 1 AND pk = 1000000; PK -------------------- 0 rows selected ELAPSED TIME = 15 milliseconds ij> -- odd query! SELECT count(pk) FROM t WHERE pk = 1 AND pk > 900000; 1 ----------- 0 1 row selected ELAPSED TIME = 47 milliseconds ij> -- Run 2 SELECT pk FROM t WHERE pk = 1; PK -------------------- 1 1 row selected ELAPSED TIME = 16 milliseconds ij> SELECT pk FROM t WHERE pk IN (1, 1000000); PK -------------------- 1 1000000 2 rows selected ELAPSED TIME = 0 milliseconds ij> SELECT pk FROM t WHERE pk = 1 OR pk = 1000000; PK -------------------- 1 1000000 2 rows selected ELAPSED TIME = 15 milliseconds ij> SELECT pk FROM t WHERE pk = 1 AND pk = 1000000; PK -------------------- 0 rows selected ELAPSED TIME = 16 milliseconds ij> -- odd query! SELECT count(pk) FROM t WHERE pk = 1 AND pk > 900000; 1 ----------- 0 1 row selected ELAPSED TIME = 15 milliseconds Brish --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
