PushDown Returns 0: SELECT * FROM oneToTenFiltered WHERE 1 > a | 38 ms | Passed |
PushDown Returns 0: SELECT * FROM oneToTenFiltered WHERE a < 1 | 42 ms | Passed |
PushDown Returns 0: SELECT * FROM oneToTenFiltered WHERE a = 20 | 41 ms | Passed |
PushDown Returns 0: SELECT a, b, c FROM oneToTenFiltered WHERE c like '%Ee%' | 35 ms | Passed |
PushDown Returns 0: SELECT a, b, c FROM oneToTenFiltered WHERE c like '%d' | 34 ms | Passed |
PushDown Returns 0: SELECT a, b, c FROM oneToTenFiltered WHERE c like 'C%' | 35 ms | Passed |
PushDown Returns 10: SELECT * FROM oneToTenFiltered WHERE b = 1 | 37 ms | Passed |
PushDown Returns 10: SELECT c FROM oneToTenFiltered WHERE A + b > 9 | 69 ms | Passed |
PushDown Returns 1: SELECT * FROM oneToTenFiltered WHERE 1 = a | 62 ms | Passed |
PushDown Returns 1: SELECT * FROM oneToTenFiltered WHERE A = 1 | 60 ms | Passed |
PushDown Returns 1: SELECT * FROM oneToTenFiltered WHERE a = 1 | 37 ms | Passed |
PushDown Returns 1: SELECT a FROM oneToTenFiltered WHERE A = 1 | 38 ms | Passed |
PushDown Returns 1: SELECT a, b FROM oneToTenFiltered WHERE A = 1 | 48 ms | Passed |
PushDown Returns 1: SELECT a, b, c FROM oneToTenFiltered WHERE c like '%D' | 45 ms | Passed |
PushDown Returns 1: SELECT a, b, c FROM oneToTenFiltered WHERE c like '%eE%' | 36 ms | Passed |
PushDown Returns 1: SELECT a, b, c FROM oneToTenFiltered WHERE c like 'c%' | 36 ms | Passed |
PushDown Returns 1: SELECT b FROM oneToTenFiltered WHERE A = 1 | 39 ms | Passed |
PushDown Returns 1: SELECT c FROM oneToTenFiltered WHERE c = 'aaaaaAAAAA' | 61 ms | Passed |
PushDown Returns 1: SELECT c FROM oneToTenFiltered WHERE c IN ('aaaaaAAAAA', 'foo') | 35 ms | Passed |
PushDown Returns 2: SELECT * FROM oneToTenFiltered WHERE 2 >= a | 42 ms | Passed |
PushDown Returns 2: SELECT * FROM oneToTenFiltered WHERE a <= 2 | 36 ms | Passed |
PushDown Returns 3: SELECT * FROM oneToTenFiltered WHERE a < 5 AND a > 1 | 44 ms | Passed |
PushDown Returns 3: SELECT * FROM oneToTenFiltered WHERE a IN (1,3,5) | 43 ms | Passed |
PushDown Returns 3: SELECT a FROM oneToTenFiltered WHERE a + b > 9 AND b < 16 AND c IN ('bbbbbBBBBB', 'cccccCCCCC', 'dddddDDDDD', 'foo') | 40 ms | Passed |
PushDown Returns 4: SELECT * FROM oneToTenFiltered WHERE a < 3 OR a > 8 | 36 ms | Passed |
PushDown Returns 5: SELECT * FROM oneToTenFiltered WHERE NOT (a < 6) | 41 ms | Passed |
PushDown Returns 8: SELECT * FROM oneToTenFiltered WHERE a > 1 AND a < 10 | 38 ms | Passed |
PushDown Returns 9: SELECT * FROM oneToTenFiltered WHERE 1 < a | 49 ms | Passed |
PushDown Returns 9: SELECT * FROM oneToTenFiltered WHERE 2 <= a | 39 ms | Passed |
PushDown Returns 9: SELECT * FROM oneToTenFiltered WHERE a > 1 | 69 ms | Passed |
PushDown Returns 9: SELECT * FROM oneToTenFiltered WHERE a >= 2 | 48 ms | Passed |
SELECT * FROM oneToTenFiltered | 0.44 sec | Passed |
SELECT A AS b FROM oneToTenFiltered | 93 ms | Passed |
SELECT a * 2 FROM oneToTenFiltered | 0.11 sec | Passed |
SELECT a FROM oneToTenFiltered | 0.1 sec | Passed |
SELECT a, b FROM oneToTenFiltered | 0.19 sec | Passed |
SELECT a, b FROM oneToTenFiltered WHERE A = 1 | 0.11 sec | Passed |
SELECT a, b FROM oneToTenFiltered WHERE NOT (a < 6) | 0.11 sec | Passed |
SELECT a, b FROM oneToTenFiltered WHERE a < 3 OR a > 8 | 0.1 sec | Passed |
SELECT a, b FROM oneToTenFiltered WHERE a < 5 AND a > 1 | 0.11 sec | Passed |
SELECT a, b FROM oneToTenFiltered WHERE a = 1 | 0.1 sec | Passed |
SELECT a, b FROM oneToTenFiltered WHERE a IN (1,3,5) | 0.1 sec | Passed |
SELECT a, b FROM oneToTenFiltered WHERE a IS NOT NULL | 0.15 sec | Passed |
SELECT a, b FROM oneToTenFiltered WHERE a IS NULL | 99 ms | Passed |
SELECT a, b FROM oneToTenFiltered WHERE b = 2 | 0.15 sec | Passed |
SELECT a, b, c FROM oneToTenFiltered WHERE c like '%D' | 0.11 sec | Passed |
SELECT a, b, c FROM oneToTenFiltered WHERE c like '%eE%' | 0.1 sec | Passed |
SELECT a, b, c FROM oneToTenFiltered WHERE c like 'c%' | 0.12 sec | Passed |
SELECT b FROM oneToTenFiltered | 81 ms | Passed |
SELECT b, a FROM oneToTenFiltered | 88 ms | Passed |
b | 0.72 sec | Passed |
b | 0.47 sec | Passed |