select count(*) from AGGREGATION_TABLE | 0.98s 3.0.0-BEFORE-PHOENIX-29 |
| select count(1) from AGGREGATION_TABLE group by HOST | 1.03s 3.0.0-BEFORE-PHOENIX-29 |
|
select core, count(1) from AGGREGATION_TABLE group by CORE | 1.2s 3.0.0-BEFORE-PHOENIX-29 |
|
select core, host, sum(ACTIVE_VISITOR) from AGGREGATION_TABLE group by core, host | 2.02s 3.0.0-BEFORE-PHOENIX-29 |
|
select AVG(DB), MIN(CORE), MAX(ACTIVE_VISITOR) from AGGREGATION_TABLE where host='CS' and DOMAIN<>'Google.com' | 2.36s 3.0.0-BEFORE-PHOENIX-29 |
|
select round(date, 'day',50), sum(core)+2 from AGGREGATION_TABLE where (CORE<10 or CORE>90) group by round(date, 'day',50), host | 1.02s 3.0.0-BEFORE-PHOENIX-29 |
|
select trunc(date, 'hour', 1000), count(DB), count(ACTIVE_VISITOR) from AGGREGATION_TABLE where feature='Login' and (core<50 or db<20 or active_visitor > 200) group by trunc(date, 'hour', 1000) | 1.29s 3.0.0-BEFORE-PHOENIX-29 |
SQL Exception - Check logs for PHOENIX-SNAPSHOT |
|
select count(active_visitor) count from AGGREGATION_TABLE | 1.67s 3.0.0-BEFORE-PHOENIX-29 |
|
select count(distinct active_visitor) count from AGGREGATION_TABLE | 1.94s 3.0.0-BEFORE-PHOENIX-29 |
|
select percentile_cont(0.9) within group (order by active_visitor asc) from AGGREGATION_TABLE | 1.94s 3.0.0-BEFORE-PHOENIX-29 |
|
select percentile_cont(0.1) within group (order by active_visitor desc) from AGGREGATION_TABLE | 1.92s 3.0.0-BEFORE-PHOENIX-29 |
|
select count(core), count(db), count(active_visitor) from AGGREGATION_TABLE | 2.17s 3.0.0-BEFORE-PHOENIX-29 |
|
select count(distinct core), count(distinct db), count(distinct active_visitor) from AGGREGATION_TABLE | 2.69s 3.0.0-BEFORE-PHOENIX-29 |
|
select percentile_cont(0.5) within group (order by core asc), percentile_cont(0.5) within group (order by db asc), percentile_cont(0.5) within group (order by active_visitor asc) from AGGREGATION_TABLE | 2.64s 3.0.0-BEFORE-PHOENIX-29 |
|
select core, count(db) count from AGGREGATION_TABLE group by CORE | 1.58s 3.0.0-BEFORE-PHOENIX-29 |
SQL Exception - Check logs for PHOENIX-SNAPSHOT |
|
select core, count(distinct db) count from AGGREGATION_TABLE group by CORE | 2.87s 3.0.0-BEFORE-PHOENIX-29 |
|
select core, percentile_cont(0.9999) within group (order by db asc) from AGGREGATION_TABLE group by CORE | 2.84s 3.0.0-BEFORE-PHOENIX-29 |
|
select count(core) from AGGREGATION_TABLE where core IN (1,25,50,75,100) | 0.76s 3.0.0-BEFORE-PHOENIX-29 |
|
select count(core) from AGGREGATION_TABLE where core < 10 and db < 200 | 0.98s 3.0.0-BEFORE-PHOENIX-29 |
|
select count(core) from AGGREGATION_TABLE where core < 10 and active_visitor < 1000 | 0.84s 3.0.0-BEFORE-PHOENIX-29 |
|
select count(core) from AGGREGATION_TABLE where core > 90 | 0.85s 3.0.0-BEFORE-PHOENIX-29 |
|
LOAD DATA AGGREGATION_TABLE [2000000 ROWS] | 112.53s 3.0.0-BEFORE-PHOENIX-29 |
|
select count(1) from IN_LIKE_TABLE where K1 in ('Z', 'D', 'F', 'X') | 0.7s 3.0.0-BEFORE-PHOENIX-29 |
| select * from IN_LIKE_TABLE where K1 in ('A','B') and K2 in ('xxx1000000','xxx2000000','xxx2000001') | 0s 3.0.0-BEFORE-PHOENIX-29 |
|
select * from IN_LIKE_TABLE where K1 in ('A', 'C', 'E', 'F', 'H') and K2 like 'xxxxxx1%' | 0.02s 3.0.0-BEFORE-PHOENIX-29 |
|
select count(*) from IN_LIKE_TABLE where K1 in ('X','A','B','C','D','E','F','G','H','I','Z') and K2 like '%1%' | 1.14s 3.0.0-BEFORE-PHOENIX-29 |
|
select count(*) from IN_LIKE_TABLE where (K1 in ('A','E','F','G','H','I','Z') or K1 like 'E%') and (K2 like '%xx1%' or K2 like '%xxxxxx2%') | 1.14s 3.0.0-BEFORE-PHOENIX-29 |
|
LOAD DATA IN_LIKE_TABLE [2000000 ROWS] | 90.93s 3.0.0-BEFORE-PHOENIX-29 |
|
select count(*) from INDEXED_TABLE | 0.79s 3.0.0-BEFORE-PHOENIX-29 |
| select /*+ INDEX(INDEXED_TABLE idx1 idx2 idx3 idx4) */ count(*) from INDEXED_TABLE | 2.18s 3.0.0-BEFORE-PHOENIX-29 |
|
select /*+ INDEX(INDEXED_TABLE ids1 ids2 ids3 ids4) */ count(*) from INDEXED_TABLE | 0.69s 3.0.0-BEFORE-PHOENIX-29 |
|
select /*+NO_INDEX*/ count(*) from INDEXED_TABLE | 1.46s 3.0.0-BEFORE-PHOENIX-29 |
|
select round(date, 'day',50), sum(core)+2 from INDEXED_TABLE where (CORE<10 or CORE>90) group by round(date, 'day',50), host | 0.25s 3.0.0-BEFORE-PHOENIX-29 |
|
select /*+NO_INDEX*/ round(date, 'day',50), sum(core)+2 from INDEXED_TABLE where (CORE<10 or CORE>90) group by round(date, 'day',50), hostSQL Exception - Check logs for 3.0.0-BEFORE-PHOENIX-29 |
SQL Exception - Check logs for PHOENIX-SNAPSHOT |
|
select count(core) from INDEXED_TABLE where core IN (1,100) | 0.12s 3.0.0-BEFORE-PHOENIX-29 |
|
select /*+ INDEX(INDEXED_TABLE idx1 idx2 idx3 idx4) */ count(core) from INDEXED_TABLE where core IN (1,100) | 0.08s 3.0.0-BEFORE-PHOENIX-29 |
|
select /*+ INDEX(INDEXED_TABLE ids1 ids2 ids3 ids4) */ count(core) from INDEXED_TABLE where core IN (1,100) | 0.1s 3.0.0-BEFORE-PHOENIX-29 |
|
select /*+NO_INDEX*/ count(core) from INDEXED_TABLE where core IN (1,100) | 1.18s 3.0.0-BEFORE-PHOENIX-29 |
|
select count(core) from INDEXED_TABLE where core IN (1,25,50,75,100) | 0.13s 3.0.0-BEFORE-PHOENIX-29 |
|
select /*+ INDEX(INDEXED_TABLE idx1 idx2 idx3 idx4) */ count(core) from INDEXED_TABLE where core IN (1,25,50,75,100) | 0.16s 3.0.0-BEFORE-PHOENIX-29 |
|
select /*+ INDEX(INDEXED_TABLE ids1 ids2 ids3 ids4) */ count(core) from INDEXED_TABLE where core IN (1,25,50,75,100) | 0.11s 3.0.0-BEFORE-PHOENIX-29 |
|
select /*+NO_INDEX*/ count(core) from INDEXED_TABLE where core IN (1,25,50,75,100) | 1.18s 3.0.0-BEFORE-PHOENIX-29 |
|
select count(core) from INDEXED_TABLE where core < 10 and db < 200 | 0.19s 3.0.0-BEFORE-PHOENIX-29 |
|
select /*+ INDEX(INDEXED_TABLE idx1 idx2 idx3 idx4) */ count(core) from INDEXED_TABLE where core < 10 and db < 200 | 0.81s 3.0.0-BEFORE-PHOENIX-29 |
|
select /*+ INDEX(INDEXED_TABLE ids1 ids2 ids3 ids4) */ count(core) from INDEXED_TABLE where core < 10 and db < 200 | 0.18s 3.0.0-BEFORE-PHOENIX-29 |
|
select /*+NO_INDEX*/ count(core) from INDEXED_TABLE where core < 10 and db < 200 | 1.44s 3.0.0-BEFORE-PHOENIX-29 |
|
select count(core) from INDEXED_TABLE where core < 100 and db < 2000 | 0.99s 3.0.0-BEFORE-PHOENIX-29 |
|
select /*+NO_INDEX*/ count(core) from INDEXED_TABLE where core < 100 and db < 2000 | 3.02s 3.0.0-BEFORE-PHOENIX-29 |
|
select count(core) from INDEXED_TABLE where core > 90 | 0.17s 3.0.0-BEFORE-PHOENIX-29 |
|
select /*+NO_INDEX*/ count(core) from INDEXED_TABLE where core > 90 | 1.29s 3.0.0-BEFORE-PHOENIX-29 |
|
select count(core) from INDEXED_TABLE where core > 0 | 0.9s 3.0.0-BEFORE-PHOENIX-29 |
|
select /*+NO_INDEX*/ count(core) from INDEXED_TABLE where core > 0 | 2.02s 3.0.0-BEFORE-PHOENIX-29 |
|
select db from INDEXED_TABLE where db >5 and db <7 order by db | 0.07s 3.0.0-BEFORE-PHOENIX-29 |
|
select /*+NO_INDEX*/ db from INDEXED_TABLE where db >5 and db <7 order by db | 1.97s 3.0.0-BEFORE-PHOENIX-29 |
|
select db from INDEXED_TABLE order by db limit 10 | 0.08s 3.0.0-BEFORE-PHOENIX-29 |
|
select /*+NO_INDEX*/ db from INDEXED_TABLE order by db limit 10 | 2.47s 3.0.0-BEFORE-PHOENIX-29 |
|
CREATE INDEX idx5 ON INDEXED_TABLE (CORE) INCLUDE (DB,ACTIVE_VISITOR) | 34.95s 3.0.0-BEFORE-PHOENIX-29 |
|
LOAD DATA INDEXED_TABLE [2000000 ROWS] | 445.68s 3.0.0-BEFORE-PHOENIX-29 |
|
select count(*) from INDEXED_TABLE_MUTABLE | 1.19s 3.0.0-BEFORE-PHOENIX-29 |
| select /*+ INDEX(INDEXED_TABLE_MUTABLE midx1 midx2 midx3 midx4) */ count(*) from INDEXED_TABLE_MUTABLE | 1.97s 3.0.0-BEFORE-PHOENIX-29 |
|
select /*+ INDEX(INDEXED_TABLE_MUTABLE mids1 mids2 mids3 mids4) */ count(*) from INDEXED_TABLE_MUTABLE | 0.83s 3.0.0-BEFORE-PHOENIX-29 |
|
select /*+NO_INDEX*/ count(*) from INDEXED_TABLE_MUTABLE | 1.42s 3.0.0-BEFORE-PHOENIX-29 |
|
select round(date, 'day',50), sum(core)+2 from INDEXED_TABLE_MUTABLE where (CORE<10 or CORE>90) group by round(date, 'day',50), host | 0.45s 3.0.0-BEFORE-PHOENIX-29 |
|
select /*+NO_INDEX*/ round(date, 'day',50), sum(core)+2 from INDEXED_TABLE_MUTABLE where (CORE<10 or CORE>90) group by round(date, 'day',50), host | 1.62s 3.0.0-BEFORE-PHOENIX-29 |
|
select count(core) from INDEXED_TABLE_MUTABLE where core IN (1,100) | 0.15s 3.0.0-BEFORE-PHOENIX-29 |
|
select /*+ INDEX(INDEXED_TABLE_MUTABLE midx1 midx2 midx3 midx4) */ count(core) from INDEXED_TABLE_MUTABLE where core IN (1,100) | 0.08s 3.0.0-BEFORE-PHOENIX-29 |
|
select /*+ INDEX(INDEXED_TABLE_MUTABLE mids1 mids2 mids3 mids4) */ count(core) from INDEXED_TABLE_MUTABLE where core IN (1,100) | 0.14s 3.0.0-BEFORE-PHOENIX-29 |
|
select /*+NO_INDEX*/ count(core) from INDEXED_TABLE_MUTABLE where core IN (1,100) | 1.06s 3.0.0-BEFORE-PHOENIX-29 |
|
select count(core) from INDEXED_TABLE_MUTABLE where core IN (1,25,50,75,100) | 0.18s 3.0.0-BEFORE-PHOENIX-29 |
|
select /*+ INDEX(INDEXED_TABLE_MUTABLE midx1 midx2 midx3 midx4) */ count(core) from INDEXED_TABLE_MUTABLE where core IN (1,25,50,75,100) | 0.12s 3.0.0-BEFORE-PHOENIX-29 |
|
select /*+ INDEX(INDEXED_TABLE_MUTABLE mids1 mids2 mids3 mids4) */ count(core) from INDEXED_TABLE_MUTABLE where core IN (1,25,50,75,100) | 0.16s 3.0.0-BEFORE-PHOENIX-29 |
|
select /*+NO_INDEX*/ count(core) from INDEXED_TABLE_MUTABLE where core IN (1,25,50,75,100) | 1.09s 3.0.0-BEFORE-PHOENIX-29 |
|
select count(core) from INDEXED_TABLE_MUTABLE where core < 10 and db < 200 | 0.42s 3.0.0-BEFORE-PHOENIX-29 |
|
select /*+ INDEX(INDEXED_TABLE_MUTABLE midx1 midx2 midx3 midx4) */ count(core) from INDEXED_TABLE_MUTABLE where core < 10 and db < 200 | 0.55s 3.0.0-BEFORE-PHOENIX-29 |
|
select /*+ INDEX(INDEXED_TABLE_MUTABLE mids1 mids2 mids3 mids4) */ count(core) from INDEXED_TABLE_MUTABLE where core < 10 and db < 200 | 0.44s 3.0.0-BEFORE-PHOENIX-29 |
|
select /*+NO_INDEX*/ count(core) from INDEXED_TABLE_MUTABLE where core < 10 and db < 200 | 1.38s 3.0.0-BEFORE-PHOENIX-29 |
|
select count(core) from INDEXED_TABLE_MUTABLE where core < 100 and db < 2000 | 1.37s 3.0.0-BEFORE-PHOENIX-29 |
|
select /*+NO_INDEX*/ count(core) from INDEXED_TABLE_MUTABLE where core < 100 and db < 2000 | 2.9s 3.0.0-BEFORE-PHOENIX-29 |
|
select count(core) from INDEXED_TABLE_MUTABLE where core > 90 | 0.23s 3.0.0-BEFORE-PHOENIX-29 |
|
select /*+NO_INDEX*/ count(core) from INDEXED_TABLE_MUTABLE where core > 90 | 1.21s 3.0.0-BEFORE-PHOENIX-29 |
|
select count(core) from INDEXED_TABLE_MUTABLE where core > 0 | 0.92s 3.0.0-BEFORE-PHOENIX-29 |
|
select /*+NO_INDEX*/ count(core) from INDEXED_TABLE_MUTABLE where core > 0 | 1.94s 3.0.0-BEFORE-PHOENIX-29 |
|
select db from INDEXED_TABLE_MUTABLE where db >5 and db <7 order by db | 0.16s 3.0.0-BEFORE-PHOENIX-29 |
|
select /*+NO_INDEX*/ db from INDEXED_TABLE_MUTABLE where db >5 and db <7 order by db | 1.84s 3.0.0-BEFORE-PHOENIX-29 |
|
select db from INDEXED_TABLE_MUTABLE order by db limit 10 | 1.01s 3.0.0-BEFORE-PHOENIX-29 |
|
select /*+NO_INDEX*/ db from INDEXED_TABLE_MUTABLE order by db limit 10 | 2.35s 3.0.0-BEFORE-PHOENIX-29 |
|
CREATE INDEX midx5 ON INDEXED_TABLE_MUTABLE (CORE) INCLUDE (DB,ACTIVE_VISITOR) | 43.64s 3.0.0-BEFORE-PHOENIX-29 |
|
LOAD DATA INDEXED_TABLE_MUTABLE [2000000 ROWS] | 706.48s 3.0.0-BEFORE-PHOENIX-29 |
|
select count(1) from TABLE_6CF where K1 in ('A', 'B', 'C', 'D') | 1.51s 3.0.0-BEFORE-PHOENIX-29 |
| select count(1) from TABLE_6CF where K1 in ('A', 'C') | 1.38s 3.0.0-BEFORE-PHOENIX-29 |
|
select count(*) from TABLE_6CF where f < 1000 | 1.26s 3.0.0-BEFORE-PHOENIX-29 |
|
select a,b,c,d,e,f from TABLE_6CF where B>1000 and B<2000 and f>1000 and f<2000 | 1.31s 3.0.0-BEFORE-PHOENIX-29 |
|
select sum(a),sum(b),sum(c),sum(d) from TABLE_6CF group by K1 | 5.12s 3.0.0-BEFORE-PHOENIX-29 |
|
select count(*) from TABLE_6CF group by A | 1.63s 3.0.0-BEFORE-PHOENIX-29 |
|
select count(*) from TABLE_6CF group by B | 2.62s 3.0.0-BEFORE-PHOENIX-29 |
|
select count(*) from TABLE_6CF where f < 10000 | 2.24s 3.0.0-BEFORE-PHOENIX-29 |
|
LOAD DATA TABLE_6CF [2000000 ROWS] | 105.9s 3.0.0-BEFORE-PHOENIX-29 |
|
select count(1) from TABLE_1CF where K1 in ('A', 'B', 'C', 'D') | 1.69s 3.0.0-BEFORE-PHOENIX-29 |
| select count(1) from TABLE_1CF where K1 in ('A', 'C') | 1.6s 3.0.0-BEFORE-PHOENIX-29 |
|
select count(*) from TABLE_1CF where f < 1000 | 1.95s 3.0.0-BEFORE-PHOENIX-29 |
|
select a,b,c,d,e,f from TABLE_1CF where B>1000 and B<2000 and f>1000 and f<2000 | 2.3s 3.0.0-BEFORE-PHOENIX-29 |
|
select sum(a),sum(b),sum(c),sum(d) from TABLE_1CF group by K1 | 3.52s 3.0.0-BEFORE-PHOENIX-29 |
|
select count(*) from TABLE_1CF group by A | 1.87s 3.0.0-BEFORE-PHOENIX-29 |
|
select count(*) from TABLE_1CF group by B | 2.35s 3.0.0-BEFORE-PHOENIX-29 |
|
select count(*) from TABLE_1CF where f < 10000 | 2.24s 3.0.0-BEFORE-PHOENIX-29 |
|
LOAD DATA TABLE_1CF [2000000 ROWS] | 100.38s 3.0.0-BEFORE-PHOENIX-29 |
|