Phoenix SNAPSHOT Performance

Phoenix Performance Result :: Tue Jul 30 21:06:41 PDT 2013

AGGREGATION_TEST_TABLE
Various server side grouped/un-grouped aggregation functions. Data is pre-split in 9 regions over a 4 region server cluster.

ROWS 4000000 [4M]

DDL CREATE TABLE $TABLE (HOST CHAR(2) NOT NULL,DOMAIN VARCHAR NOT NULL,FEATURE VARCHAR NOT NULL,DATE DATE NOT NULL,USAGE.CORE BIGINT,USAGE.DB BIGINT,STATS.ACTIVE_VISITOR INTEGER CONSTRAINT PK PRIMARY KEY (HOST, DOMAIN, FEATURE, DATE)) SPLIT ON ('CSGoogle','CSSalesforce','EUApple','EUGoogle','EUSalesforce','NAApple','NAGoogle','NASalesforce')

DATA GENERATOR
STRING :: Values: NA|CS|EU
STRING :: Values: Salesforce.com|Apple.com|Google.com|Yelp.com
STRING :: Values: Login|Report|Dashboard|Sales|UI
DATE :: Values: SEQUENTIAL
INTEGER :: Max. Value: 100 Values: RANDOM
INTEGER :: Max. Value: 2000 Values: RANDOM
INTEGER :: Max. Value: 10000 Values: RANDOM

QUERIES

select count(*) from AGGREGATION_TEST_TABLE

2.39s CURRENT-SNAPSHOT

2.42s LAST-SNAPSHOT

2.18s PHOENIX-1.1

2.27s PHOENIX-1.2.0

select count(1) from AGGREGATION_TEST_TABLE group by HOST

2.42s CURRENT-SNAPSHOT

2.46s LAST-SNAPSHOT

2.28s PHOENIX-1.1

2.3s PHOENIX-1.2.0

select MIN(CORE) from AGGREGATION_TEST_TABLE group by DOMAIN

2.73s CURRENT-SNAPSHOT

2.8s LAST-SNAPSHOT

2.58s PHOENIX-1.1

2.61s PHOENIX-1.2.0

select core, count(1) from AGGREGATION_TEST_TABLE group by CORE

2.69s CURRENT-SNAPSHOT

2.76s LAST-SNAPSHOT

2.64s PHOENIX-1.1

2.52s PHOENIX-1.2.0

select core, host, sum(ACTIVE_VISITOR) from AGGREGATION_TEST_TABLE group by core, host

4.32s CURRENT-SNAPSHOT

4.37s LAST-SNAPSHOT

4.19s PHOENIX-1.1

4.12s PHOENIX-1.2.0

select AVG(DB), MIN(CORE), MAX(ACTIVE_VISITOR) from AGGREGATION_TEST_TABLE where host='CS' and DOMAIN<>'Google.com'

5.32s CURRENT-SNAPSHOT

5.87s LAST-SNAPSHOT

5.3s PHOENIX-1.1

5.33s PHOENIX-1.2.0

select round(date, 'day',50), sum(core)+2 from AGGREGATION_TEST_TABLE where (CORE<10 or CORE>90) group by round(date, 'day',50), host

1.91s CURRENT-SNAPSHOT

1.93s LAST-SNAPSHOT

1.85s PHOENIX-1.1

1.78s PHOENIX-1.2.0

select trunc(date, 'hour', 1000), count(DB), count(ACTIVE_VISITOR) from AGGREGATION_TEST_TABLE where feature='Login' and (core<50 or db<20 or active_visitor > 200) group by trunc(date, 'hour', 1000)

2.67s CURRENT-SNAPSHOT

2.65s LAST-SNAPSHOT

3.5s PHOENIX-1.1

2.44s PHOENIX-1.2.0

select count(active_visitor) count from AGGREGATION_TEST_TABLE

3.85s CURRENT-SNAPSHOT

3.98s LAST-SNAPSHOT

3.58s PHOENIX-1.1

3.55s PHOENIX-1.2.0

select count(distinct active_visitor) count from AGGREGATION_TEST_TABLE

4.26s CURRENT-SNAPSHOT

4.43s LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

select percentile_cont(0.9) within group (order by active_visitor asc) from AGGREGATION_TEST_TABLE

4.35s CURRENT-SNAPSHOT

4.48s LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

select percentile_cont(0.1) within group (order by active_visitor desc) from AGGREGATION_TEST_TABLE

4.28s CURRENT-SNAPSHOT

4.4s LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

select count(core), count(db), count(active_visitor) from AGGREGATION_TEST_TABLE

5.3s CURRENT-SNAPSHOT

5.6s LAST-SNAPSHOT

5.02s PHOENIX-1.1

5s PHOENIX-1.2.0

select count(distinct core), count(distinct db), count(distinct active_visitor) from AGGREGATION_TEST_TABLE

6.25s CURRENT-SNAPSHOT

6.49s LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

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_TEST_TABLE

6.16s CURRENT-SNAPSHOT

6.48s LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

select core, count(db) count from AGGREGATION_TEST_TABLE group by CORE

3.96s CURRENT-SNAPSHOT

4.18s LAST-SNAPSHOT

3.83s PHOENIX-1.1

3.66s PHOENIX-1.2.0

select core, count(distinct db) count from AGGREGATION_TEST_TABLE group by CORE

5.36s CURRENT-SNAPSHOT

5.6s LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

select core, percentile_cont(0.9999) within group (order by db asc) from AGGREGATION_TEST_TABLE group by CORE

5.44s CURRENT-SNAPSHOT

5.68s LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

select count(core) from AGGREGATION_TEST_TABLE where core < 10 and active_visitor < 1000

1.54s CURRENT-SNAPSHOT

1.53s LAST-SNAPSHOT

2.81s PHOENIX-1.1

1.42s PHOENIX-1.2.0

select count(core) from AGGREGATION_TEST_TABLE where core < 50 and active_visitor < 5000

1.6s CURRENT-SNAPSHOT

1.58s LAST-SNAPSHOT

3.35s PHOENIX-1.1

1.49s PHOENIX-1.2.0

select count(core) from AGGREGATION_TEST_TABLE where core < 100 and active_visitor < 10000

1.65s CURRENT-SNAPSHOT

1.64s LAST-SNAPSHOT

4.59s PHOENIX-1.1

1.56s PHOENIX-1.2.0

select count(core) from AGGREGATION_TEST_TABLE where core > 90

1.68s CURRENT-SNAPSHOT

1.7s LAST-SNAPSHOT

1.51s PHOENIX-1.1

1.49s PHOENIX-1.2.0

select count(core) from AGGREGATION_TEST_TABLE where core > 50

2.31s CURRENT-SNAPSHOT

2.35s LAST-SNAPSHOT

2.11s PHOENIX-1.1

2.12s PHOENIX-1.2.0

select count(core) from AGGREGATION_TEST_TABLE where core > 0

2.99s CURRENT-SNAPSHOT

3.13s LAST-SNAPSHOT

2.78s PHOENIX-1.1

2.77s PHOENIX-1.2.0

LOAD DATA [4000000 ROWS]

128.35s CURRENT-SNAPSHOT

130.4s LAST-SNAPSHOT

123.62s PHOENIX-1.1

147.5s PHOENIX-1.2.0

IN_LIKE_TABLE
Phoenix 1.2+ uses skip scan that gives significant performance improvement for IN/LIKE queries.

ROWS 4000000 [4M]

DDL CREATE TABLE IF NOT EXISTS $TABLE (K1 CHAR(1) NOT NULL, K2 VARCHAR NOT NULL, CF.A INTEGER, CF.B VARCHAR, CF.C VARCHAR CONSTRAINT PK PRIMARY KEY (K1,K2)) SPLIT ON ('B','C','D','E','F','G','H','I')

DATA GENERATOR
STRING :: Values: A|B|C|D|E|F|G|H|I
STRING :: Length: 10 Values: SEQUENTIAL
INTEGER :: Max. Value: 1000000 Values: RANDOM
STRING :: Length: 50 Values: RANDOM
STRING :: Length: 50 Values: RANDOM

QUERIES

select count(1) from IN_LIKE_TABLE where K1 in ('Z', 'D', 'F', 'X')

1.15s CURRENT-SNAPSHOT

1.16s LAST-SNAPSHOT

1.19s PHOENIX-1.1

1.15s PHOENIX-1.2.0

select * from IN_LIKE_TABLE where K1 in ('A','B') and K2 in ('xxx1000000','xxx2000000','xxx2000001')

0.01s CURRENT-SNAPSHOT

0.01s LAST-SNAPSHOT

1.8s PHOENIX-1.1

0.01s PHOENIX-1.2.0

select * from IN_LIKE_TABLE where K1 in ('A', 'C', 'E', 'F', 'H') and K2 like 'xxxxxx1%'

0.01s CURRENT-SNAPSHOT

0.01s LAST-SNAPSHOT

8.04s PHOENIX-1.1

0.02s PHOENIX-1.2.0

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.92s CURRENT-SNAPSHOT

1.85s LAST-SNAPSHOT

1.7s PHOENIX-1.1

1.83s PHOENIX-1.2.0

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.87s CURRENT-SNAPSHOT

1.88s LAST-SNAPSHOT

1.76s PHOENIX-1.1

1.85s PHOENIX-1.2.0

LOAD DATA [4000000 ROWS]

102.08s CURRENT-SNAPSHOT

101.48s LAST-SNAPSHOT

103.34s PHOENIX-1.1

127.92s PHOENIX-1.2.0

INDEXED_TEST_TABLE
Indexing test. Phoenix 2.0+ feature. See explain plan by hovering over version label to see which index table is used.

ROWS 4000000 [4M]

DDL CREATE TABLE $TABLE (HOST CHAR(2) NOT NULL,DOMAIN VARCHAR NOT NULL,FEATURE VARCHAR NOT NULL,DATE DATE NOT NULL,USAGE.CORE BIGINT,USAGE.DB BIGINT,STATS.ACTIVE_VISITOR INTEGER CONSTRAINT PK PRIMARY KEY (HOST, DOMAIN, FEATURE, DATE)) IMMUTABLE_ROWS=true,MAX_FILESIZE=30485760;CREATE INDEX INDEX_CORE ON $TABLE (CORE) MAX_FILESIZE=10185760;CREATE INDEX INDEX_DB ON $TABLE (DB) MAX_FILESIZE=10185760;CREATE INDEX INDEX_DB_ACTIVE_VISITOR ON $TABLE (DB,ACTIVE_VISITOR) MAX_FILESIZE=15285760;CREATE INDEX INDEX_ALL ON $TABLE (CORE,DB,ACTIVE_VISITOR) MAX_FILESIZE=15485760;

DATA GENERATOR
STRING :: Values: NA|CS|EU
STRING :: Values: Salesforce.com|Apple.com|Google.com|Yelp.com
STRING :: Values: Login|Report|Dashboard|Sales|UI
DATE :: Values: SEQUENTIAL
INTEGER :: Max. Value: 100 Values: RANDOM
INTEGER :: Max. Value: 2000 Values: RANDOM
INTEGER :: Max. Value: 10000 Values: RANDOM

QUERIES

select count(*) from INDEXED_TEST_TABLE

1.77s CURRENT-SNAPSHOT

1.96s LAST-SNAPSHOT

1.91s PHOENIX-1.1

1.92s PHOENIX-1.2.0

select /*+NO_INDEX*/ count(*) from INDEXED_TEST_TABLE

1.76s CURRENT-SNAPSHOT

1.94s LAST-SNAPSHOT

1.89s PHOENIX-1.1

1.89s PHOENIX-1.2.0

select count(1) from INDEXED_TEST_TABLE group by HOST

1.96s CURRENT-SNAPSHOT

2.11s LAST-SNAPSHOT

2.02s PHOENIX-1.1

1.99s PHOENIX-1.2.0

select /*+NO_INDEX*/ count(1) from INDEXED_TEST_TABLE group by HOST

1.95s CURRENT-SNAPSHOT

2.08s LAST-SNAPSHOT

1.98s PHOENIX-1.1

1.95s PHOENIX-1.2.0

select MIN(CORE) from INDEXED_TEST_TABLE group by DOMAIN

2.22s CURRENT-SNAPSHOT

2.39s LAST-SNAPSHOT

2.26s PHOENIX-1.1

2.24s PHOENIX-1.2.0

select /*+NO_INDEX*/ MIN(CORE) from INDEXED_TEST_TABLE group by DOMAIN

2.22s CURRENT-SNAPSHOT

2.41s LAST-SNAPSHOT

2.29s PHOENIX-1.1

2.28s PHOENIX-1.2.0

select core, count(1) from INDEXED_TEST_TABLE group by CORE

0.92s CURRENT-SNAPSHOT

1.07s LAST-SNAPSHOT

2.27s PHOENIX-1.1

2.2s PHOENIX-1.2.0

select /*+NO_INDEX*/ core, count(1) from INDEXED_TEST_TABLE group by CORE

2.1s CURRENT-SNAPSHOT

2.34s LAST-SNAPSHOT

2.25s PHOENIX-1.1

2.21s PHOENIX-1.2.0

select core, host, sum(ACTIVE_VISITOR) from INDEXED_TEST_TABLE group by core, host

3.45s CURRENT-SNAPSHOT

3.81s LAST-SNAPSHOT

3.75s PHOENIX-1.1

3.63s PHOENIX-1.2.0

select /*+NO_INDEX*/ core, host, sum(ACTIVE_VISITOR) from INDEXED_TEST_TABLE group by core, host

3.44s CURRENT-SNAPSHOT

3.77s LAST-SNAPSHOT

3.68s PHOENIX-1.1

3.59s PHOENIX-1.2.0

select AVG(DB), MIN(CORE), MAX(ACTIVE_VISITOR) from INDEXED_TEST_TABLE where host='CS' and DOMAIN<>'Google.com'

3.3s CURRENT-SNAPSHOT

3.44s LAST-SNAPSHOT

3.28s PHOENIX-1.1

3.46s PHOENIX-1.2.0

select /*+NO_INDEX*/ AVG(DB), MIN(CORE), MAX(ACTIVE_VISITOR) from INDEXED_TEST_TABLE where host='CS' and DOMAIN<>'Google.com'

3.27s CURRENT-SNAPSHOT

3.38s LAST-SNAPSHOT

3.28s PHOENIX-1.1

3.45s PHOENIX-1.2.0

select round(date, 'day',50), sum(core)+2 from INDEXED_TEST_TABLE where (CORE<10 or CORE>90) group by round(date, 'day',50), host

0.01s CURRENT-SNAPSHOT

0.02s LAST-SNAPSHOT

1.57s PHOENIX-1.1

1.59s PHOENIX-1.2.0

select /*+NO_INDEX*/ round(date, 'day',50), sum(core)+2 from INDEXED_TEST_TABLE where (CORE<10 or CORE>90) group by round(date, 'day',50), host

1.51s CURRENT-SNAPSHOT

1.62s LAST-SNAPSHOT

1.6s PHOENIX-1.1

1.61s PHOENIX-1.2.0

select trunc(date, 'hour', 1000), count(DB), count(ACTIVE_VISITOR) from INDEXED_TEST_TABLE where feature='Login' and (core<50 or db<20 or active_visitor > 200) group by trunc(date, 'hour', 1000)

2.2s CURRENT-SNAPSHOT

2.19s LAST-SNAPSHOT

2.99s PHOENIX-1.1

2.15s PHOENIX-1.2.0

select /*+NO_INDEX*/ trunc(date, 'hour', 1000), count(DB), count(ACTIVE_VISITOR) from INDEXED_TEST_TABLE where feature='Login' and (core<50 or db<20 or active_visitor > 200) group by trunc(date, 'hour', 1000)

2.18s CURRENT-SNAPSHOT

2.2s LAST-SNAPSHOT

2.97s PHOENIX-1.1

2.14s PHOENIX-1.2.0

select count(active_visitor) count from INDEXED_TEST_TABLE

2.92s CURRENT-SNAPSHOT

3.26s LAST-SNAPSHOT

3.01s PHOENIX-1.1

3.01s PHOENIX-1.2.0

select /*+NO_INDEX*/ count(active_visitor) count from INDEXED_TEST_TABLE

2.93s CURRENT-SNAPSHOT

3.23s LAST-SNAPSHOT

2.97s PHOENIX-1.1

3.01s PHOENIX-1.2.0

select count(distinct active_visitor) count from INDEXED_TEST_TABLE

3.25s CURRENT-SNAPSHOT

3.62s LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

select /*+NO_INDEX*/ count(distinct active_visitor) count from INDEXED_TEST_TABLE

3.21s CURRENT-SNAPSHOT

3.61s LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

select percentile_cont(0.9) within group (order by active_visitor asc) from INDEXED_TEST_TABLE

3.28s CURRENT-SNAPSHOT

3.62s LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

select /*+NO_INDEX*/ percentile_cont(0.9) within group (order by active_visitor asc) from INDEXED_TEST_TABLE

3.22s CURRENT-SNAPSHOT

3.62s LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

select percentile_cont(0.1) within group (order by active_visitor desc) from INDEXED_TEST_TABLE

3.25s CURRENT-SNAPSHOT

3.6s LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

select /*+NO_INDEX*/ percentile_cont(0.1) within group (order by active_visitor desc) from INDEXED_TEST_TABLE

3.22s CURRENT-SNAPSHOT

3.58s LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

select count(core), count(db), count(active_visitor) from INDEXED_TEST_TABLE

4.1s CURRENT-SNAPSHOT

4.49s LAST-SNAPSHOT

4.21s PHOENIX-1.1

4.25s PHOENIX-1.2.0

select /*+NO_INDEX*/ count(core), count(db), count(active_visitor) from INDEXED_TEST_TABLE

4.1s CURRENT-SNAPSHOT

4.5s LAST-SNAPSHOT

4.15s PHOENIX-1.1

4.24s PHOENIX-1.2.0

select count(distinct core), count(distinct db), count(distinct active_visitor) from INDEXED_TEST_TABLE

4.72s CURRENT-SNAPSHOT

5.16s LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

select /*+NO_INDEX*/ count(distinct core), count(distinct db), count(distinct active_visitor) from INDEXED_TEST_TABLE

4.66s CURRENT-SNAPSHOT

5.11s LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

4.73s CURRENT-SNAPSHOT

5.17s LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

select /*+NO_INDEX*/ 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 INDEXED_TEST_TABLE

4.74s CURRENT-SNAPSHOT

5.16s LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

select core, count(db) count from INDEXED_TEST_TABLE group by CORE

0.77s CURRENT-SNAPSHOT

0.79s LAST-SNAPSHOT

3.23s PHOENIX-1.1

3.23s PHOENIX-1.2.0

select /*+NO_INDEX*/ core, count(db) count from INDEXED_TEST_TABLE group by CORE

3s CURRENT-SNAPSHOT

3.33s LAST-SNAPSHOT

3.25s PHOENIX-1.1

3.19s PHOENIX-1.2.0

select core, count(distinct db) count from INDEXED_TEST_TABLE group by CORE

0.76s CURRENT-SNAPSHOT

0.75s LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

select /*+NO_INDEX*/ core, count(distinct db) count from INDEXED_TEST_TABLE group by CORE

4.11s CURRENT-SNAPSHOT

4.64s LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

select core, percentile_cont(0.9999) within group (order by db asc) from INDEXED_TEST_TABLE group by CORE

0.94s CURRENT-SNAPSHOT

0.95s LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

select /*+NO_INDEX*/ core, percentile_cont(0.9999) within group (order by db asc) from INDEXED_TEST_TABLE group by CORE

4.35s CURRENT-SNAPSHOT

4.62s LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

select count(core) from INDEXED_TEST_TABLE where core IN (1,100)

0.11s CURRENT-SNAPSHOT

0.12s LAST-SNAPSHOT

1.2s PHOENIX-1.1

1.18s PHOENIX-1.2.0

select /*+NO_INDEX*/ count(core) from INDEXED_TEST_TABLE where core IN (1,100)

1.13s CURRENT-SNAPSHOT

1.26s LAST-SNAPSHOT

1.19s PHOENIX-1.1

1.14s PHOENIX-1.2.0

select count(core) from INDEXED_TEST_TABLE where core IN (1,25,50,75,100)

0.2s CURRENT-SNAPSHOT

0.14s LAST-SNAPSHOT

1.24s PHOENIX-1.1

1.19s PHOENIX-1.2.0

select /*+NO_INDEX*/ count(core) from INDEXED_TEST_TABLE where core IN (1,25,50,75,100)

1.15s CURRENT-SNAPSHOT

1.25s LAST-SNAPSHOT

1.22s PHOENIX-1.1

1.17s PHOENIX-1.2.0

select count(core) from INDEXED_TEST_TABLE where core < 10 and db < 200

0.52s CURRENT-SNAPSHOT

0.55s LAST-SNAPSHOT

1.5s PHOENIX-1.1

1.45s PHOENIX-1.2.0

select /*+NO_INDEX*/ count(core) from INDEXED_TEST_TABLE where core < 10 and db < 200

1.41s CURRENT-SNAPSHOT

1.49s LAST-SNAPSHOT

1.52s PHOENIX-1.1

1.52s PHOENIX-1.2.0

select count(core) from INDEXED_TEST_TABLE where core < 50 and db < 1000

0.69s CURRENT-SNAPSHOT

0.7s LAST-SNAPSHOT

2.27s PHOENIX-1.1

2.25s PHOENIX-1.2.0

select /*+NO_INDEX*/ count(core) from INDEXED_TEST_TABLE where core < 50 and db < 1000

2.17s CURRENT-SNAPSHOT

2.26s LAST-SNAPSHOT

2.28s PHOENIX-1.1

2.29s PHOENIX-1.2.0

select count(core) from INDEXED_TEST_TABLE where core < 100 and db < 2000

0.86s CURRENT-SNAPSHOT

0.85s LAST-SNAPSHOT

3.7s PHOENIX-1.1

3.56s PHOENIX-1.2.0

select /*+NO_INDEX*/ count(core) from INDEXED_TEST_TABLE where core < 100 and db < 2000

3.51s CURRENT-SNAPSHOT

3.66s LAST-SNAPSHOT

3.66s PHOENIX-1.1

3.51s PHOENIX-1.2.0

select count(core) from INDEXED_TEST_TABLE where core < 10 and active_visitor < 1000

0.53s CURRENT-SNAPSHOT

0.55s LAST-SNAPSHOT

2.36s PHOENIX-1.1

1.26s PHOENIX-1.2.0

select /*+NO_INDEX*/ count(core) from INDEXED_TEST_TABLE where core < 10 and active_visitor < 1000

1.15s CURRENT-SNAPSHOT

1.22s LAST-SNAPSHOT

2.34s PHOENIX-1.1

1.26s PHOENIX-1.2.0

select count(core) from INDEXED_TEST_TABLE where core < 50 and active_visitor < 5000

0.7s CURRENT-SNAPSHOT

0.71s LAST-SNAPSHOT

2.78s PHOENIX-1.1

1.3s PHOENIX-1.2.0

select /*+NO_INDEX*/ count(core) from INDEXED_TEST_TABLE where core < 50 and active_visitor < 5000

1.22s CURRENT-SNAPSHOT

1.28s LAST-SNAPSHOT

2.8s PHOENIX-1.1

1.34s PHOENIX-1.2.0

select count(core) from INDEXED_TEST_TABLE where core < 100 and active_visitor < 10000

0.86s CURRENT-SNAPSHOT

0.86s LAST-SNAPSHOT

3.82s PHOENIX-1.1

1.36s PHOENIX-1.2.0

select /*+NO_INDEX*/ count(core) from INDEXED_TEST_TABLE where core < 100 and active_visitor < 10000

1.25s CURRENT-SNAPSHOT

1.29s LAST-SNAPSHOT

3.84s PHOENIX-1.1

1.41s PHOENIX-1.2.0

select count(core) from INDEXED_TEST_TABLE where core > 90

0.55s CURRENT-SNAPSHOT

0.57s LAST-SNAPSHOT

1.24s PHOENIX-1.1

1.28s PHOENIX-1.2.0

select /*+NO_INDEX*/ count(core) from INDEXED_TEST_TABLE where core > 90

1.26s CURRENT-SNAPSHOT

1.33s LAST-SNAPSHOT

1.25s PHOENIX-1.1

1.3s PHOENIX-1.2.0

select count(core) from INDEXED_TEST_TABLE where core > 50

0.63s CURRENT-SNAPSHOT

0.71s LAST-SNAPSHOT

1.74s PHOENIX-1.1

1.82s PHOENIX-1.2.0

select /*+NO_INDEX*/ count(core) from INDEXED_TEST_TABLE where core > 50

1.77s CURRENT-SNAPSHOT

1.87s LAST-SNAPSHOT

1.78s PHOENIX-1.1

1.81s PHOENIX-1.2.0

select count(core) from INDEXED_TEST_TABLE where core > 0

0.71s CURRENT-SNAPSHOT

0.72s LAST-SNAPSHOT

2.33s PHOENIX-1.1

2.26s PHOENIX-1.2.0

select /*+NO_INDEX*/ count(core) from INDEXED_TEST_TABLE where core > 0

2.34s CURRENT-SNAPSHOT

2.48s LAST-SNAPSHOT

2.31s PHOENIX-1.1

2.26s PHOENIX-1.2.0

select db from INDEXED_TEST_TABLE where db >5 and db <10 order by db

0.07s CURRENT-SNAPSHOT

0.08s LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

select /*+NO_INDEX*/ db from INDEXED_TEST_TABLE where db >5 and db <10 order by db

2.14s CURRENT-SNAPSHOT

2.26s LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

select db from INDEXED_TEST_TABLE_test_table order by db limit 100

N/A for CURRENT-SNAPSHOT

N/A for LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

select /*+NO_INDEX*/ db from INDEXED_TEST_TABLE_test_table order by db limit 100

N/A for CURRENT-SNAPSHOT

N/A for LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

LOAD DATA [4000000 ROWS]

570.71s CURRENT-SNAPSHOT

569.5s LAST-SNAPSHOT

175.59s PHOENIX-1.1

213.44s PHOENIX-1.2.0

INDEXED_TEST_TABLE_LARGE
Indexing test. Phoenix 2.0+ feature. See explain plan by hovering over version label to see which index table is used.

ROWS 8000000 [8M]

DDL CREATE TABLE $TABLE (HOST CHAR(2) NOT NULL,DOMAIN VARCHAR NOT NULL,FEATURE VARCHAR NOT NULL,DATE DATE NOT NULL,USAGE.CORE BIGINT,USAGE.DB BIGINT,STATS.ACTIVE_VISITOR INTEGER CONSTRAINT PK PRIMARY KEY (HOST, DOMAIN, FEATURE, DATE)) IMMUTABLE_ROWS=true,MAX_FILESIZE=30485760;CREATE INDEX INDEX_CORE_L ON $TABLE (CORE) MAX_FILESIZE=10185760;CREATE INDEX INDEX_DB_L ON $TABLE (DB) MAX_FILESIZE=10185760;CREATE INDEX INDEX_DB_ACTIVE_VISITOR_L ON $TABLE (DB,ACTIVE_VISITOR) MAX_FILESIZE=15285760;CREATE INDEX INDEX_ALL_L ON $TABLE (CORE,DB,ACTIVE_VISITOR) MAX_FILESIZE=15485760;

DATA GENERATOR
STRING :: Values: NA|CS|EU
STRING :: Values: Salesforce.com|Apple.com|Google.com|Yelp.com
STRING :: Values: Login|Report|Dashboard|Sales|UI
DATE :: Values: SEQUENTIAL
INTEGER :: Max. Value: 100 Values: RANDOM
INTEGER :: Max. Value: 2000 Values: RANDOM
INTEGER :: Max. Value: 10000 Values: RANDOM

QUERIES

select count(*) from INDEXED_TEST_TABLE_LARGE

2.29s CURRENT-SNAPSHOT

2.52s LAST-SNAPSHOT

2.88s PHOENIX-1.1

4.04s PHOENIX-1.2.0

select /*+NO_INDEX*/ count(*) from INDEXED_TEST_TABLE_LARGE

2.26s CURRENT-SNAPSHOT

2.31s LAST-SNAPSHOT

2.76s PHOENIX-1.1

3.79s PHOENIX-1.2.0

select count(1) from INDEXED_TEST_TABLE_LARGE group by HOST

2.36s CURRENT-SNAPSHOT

2.38s LAST-SNAPSHOT

3.05s PHOENIX-1.1

3.94s PHOENIX-1.2.0

select /*+NO_INDEX*/ count(1) from INDEXED_TEST_TABLE_LARGE group by HOST

2.38s CURRENT-SNAPSHOT

2.34s LAST-SNAPSHOT

3.05s PHOENIX-1.1

4.02s PHOENIX-1.2.0

select MIN(CORE) from INDEXED_TEST_TABLE_LARGE group by DOMAIN

2.82s CURRENT-SNAPSHOT

2.73s LAST-SNAPSHOT

3.35s PHOENIX-1.1

2.73s PHOENIX-1.2.0

select /*+NO_INDEX*/ MIN(CORE) from INDEXED_TEST_TABLE_LARGE group by DOMAIN

2.81s CURRENT-SNAPSHOT

2.75s LAST-SNAPSHOT

3.32s PHOENIX-1.1

2.66s PHOENIX-1.2.0

select core, count(1) from INDEXED_TEST_TABLE_LARGE group by CORE

1.76s CURRENT-SNAPSHOT

1.79s LAST-SNAPSHOT

3.24s PHOENIX-1.1

2.57s PHOENIX-1.2.0

select /*+NO_INDEX*/ core, count(1) from INDEXED_TEST_TABLE_LARGE group by CORE

2.68s CURRENT-SNAPSHOT

2.72s LAST-SNAPSHOT

3.29s PHOENIX-1.1

2.61s PHOENIX-1.2.0

select core, host, sum(ACTIVE_VISITOR) from INDEXED_TEST_TABLE_LARGE group by core, host

4.52s CURRENT-SNAPSHOT

4.45s LAST-SNAPSHOT

5.44s PHOENIX-1.1

4.22s PHOENIX-1.2.0

select /*+NO_INDEX*/ core, host, sum(ACTIVE_VISITOR) from INDEXED_TEST_TABLE_LARGE group by core, host

4.48s CURRENT-SNAPSHOT

4.39s LAST-SNAPSHOT

5.21s PHOENIX-1.1

4.09s PHOENIX-1.2.0

select AVG(DB), MIN(CORE), MAX(ACTIVE_VISITOR) from INDEXED_TEST_TABLE_LARGE where host='CS' and DOMAIN<>'Google.com'

3.86s CURRENT-SNAPSHOT

4.04s LAST-SNAPSHOT

3.57s PHOENIX-1.1

4.17s PHOENIX-1.2.0

select /*+NO_INDEX*/ AVG(DB), MIN(CORE), MAX(ACTIVE_VISITOR) from INDEXED_TEST_TABLE_LARGE where host='CS' and DOMAIN<>'Google.com'

3.9s CURRENT-SNAPSHOT

4.03s LAST-SNAPSHOT

3.59s PHOENIX-1.1

4.13s PHOENIX-1.2.0

select round(date, 'day',50), sum(core)+2 from INDEXED_TEST_TABLE_LARGE where (CORE<10 or CORE>90) group by round(date, 'day',50), host

0.01s CURRENT-SNAPSHOT

0.01s LAST-SNAPSHOT

2.26s PHOENIX-1.1

1.72s PHOENIX-1.2.0

select /*+NO_INDEX*/ round(date, 'day',50), sum(core)+2 from INDEXED_TEST_TABLE_LARGE where (CORE<10 or CORE>90) group by round(date, 'day',50), host

1.95s CURRENT-SNAPSHOT

1.8s LAST-SNAPSHOT

2.24s PHOENIX-1.1

1.77s PHOENIX-1.2.0

select trunc(date, 'hour', 1000), count(DB), count(ACTIVE_VISITOR) from INDEXED_TEST_TABLE_LARGE where feature='Login' and (core<50 or db<20 or active_visitor > 200) group by trunc(date, 'hour', 1000)

2.6s CURRENT-SNAPSHOT

2.51s LAST-SNAPSHOT

4.25s PHOENIX-1.1

2.42s PHOENIX-1.2.0

select /*+NO_INDEX*/ trunc(date, 'hour', 1000), count(DB), count(ACTIVE_VISITOR) from INDEXED_TEST_TABLE_LARGE where feature='Login' and (core<50 or db<20 or active_visitor > 200) group by trunc(date, 'hour', 1000)

2.63s CURRENT-SNAPSHOT

2.6s LAST-SNAPSHOT

4.23s PHOENIX-1.1

2.44s PHOENIX-1.2.0

select count(active_visitor) count from INDEXED_TEST_TABLE_LARGE

3.75s CURRENT-SNAPSHOT

3.63s LAST-SNAPSHOT

4.39s PHOENIX-1.1

3.57s PHOENIX-1.2.0

select /*+NO_INDEX*/ count(active_visitor) count from INDEXED_TEST_TABLE_LARGE

3.73s CURRENT-SNAPSHOT

3.65s LAST-SNAPSHOT

4.49s PHOENIX-1.1

3.55s PHOENIX-1.2.0

select count(distinct active_visitor) count from INDEXED_TEST_TABLE_LARGE

4.46s CURRENT-SNAPSHOT

4.16s LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

select /*+NO_INDEX*/ count(distinct active_visitor) count from INDEXED_TEST_TABLE_LARGE

4.42s CURRENT-SNAPSHOT

4.06s LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

select percentile_cont(0.9) within group (order by active_visitor asc) from INDEXED_TEST_TABLE_LARGE

4.38s CURRENT-SNAPSHOT

4.13s LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

select /*+NO_INDEX*/ percentile_cont(0.9) within group (order by active_visitor asc) from INDEXED_TEST_TABLE_LARGE

4.31s CURRENT-SNAPSHOT

4.17s LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

select percentile_cont(0.1) within group (order by active_visitor desc) from INDEXED_TEST_TABLE_LARGE

4.33s CURRENT-SNAPSHOT

4.04s LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

select /*+NO_INDEX*/ percentile_cont(0.1) within group (order by active_visitor desc) from INDEXED_TEST_TABLE_LARGE

4.25s CURRENT-SNAPSHOT

4.09s LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

select count(core), count(db), count(active_visitor) from INDEXED_TEST_TABLE_LARGE

5.14s CURRENT-SNAPSHOT

4.98s LAST-SNAPSHOT

4.89s PHOENIX-1.1

5.08s PHOENIX-1.2.0

select /*+NO_INDEX*/ count(core), count(db), count(active_visitor) from INDEXED_TEST_TABLE_LARGE

5.18s CURRENT-SNAPSHOT

5.02s LAST-SNAPSHOT

4.86s PHOENIX-1.1

5s PHOENIX-1.2.0

select count(distinct core), count(distinct db), count(distinct active_visitor) from INDEXED_TEST_TABLE_LARGE

6.33s CURRENT-SNAPSHOT

5.83s LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

select /*+NO_INDEX*/ count(distinct core), count(distinct db), count(distinct active_visitor) from INDEXED_TEST_TABLE_LARGE

6.33s CURRENT-SNAPSHOT

5.93s LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

6.3s CURRENT-SNAPSHOT

5.92s LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

6.26s CURRENT-SNAPSHOT

5.93s LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

select core, count(db) count from INDEXED_TEST_TABLE_LARGE group by CORE

1.77s CURRENT-SNAPSHOT

1.77s LAST-SNAPSHOT

3.72s PHOENIX-1.1

3.72s PHOENIX-1.2.0

select /*+NO_INDEX*/ core, count(db) count from INDEXED_TEST_TABLE_LARGE group by CORE

3.8s CURRENT-SNAPSHOT

3.69s LAST-SNAPSHOT

3.7s PHOENIX-1.1

3.64s PHOENIX-1.2.0

select core, count(distinct db) count from INDEXED_TEST_TABLE_LARGE group by CORE

1.73s CURRENT-SNAPSHOT

1.81s LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

select /*+NO_INDEX*/ core, count(distinct db) count from INDEXED_TEST_TABLE_LARGE group by CORE

5.81s CURRENT-SNAPSHOT

5.81s LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

select core, percentile_cont(0.9999) within group (order by db asc) from INDEXED_TEST_TABLE_LARGE group by CORE

2.06s CURRENT-SNAPSHOT

2.03s LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

select /*+NO_INDEX*/ core, percentile_cont(0.9999) within group (order by db asc) from INDEXED_TEST_TABLE_LARGE group by CORE

5.98s CURRENT-SNAPSHOT

5.95s LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

select count(core) from INDEXED_TEST_TABLE_LARGE where core IN (1,100)

0.22s CURRENT-SNAPSHOT

0.21s LAST-SNAPSHOT

1.33s PHOENIX-1.1

1.34s PHOENIX-1.2.0

select /*+NO_INDEX*/ count(core) from INDEXED_TEST_TABLE_LARGE where core IN (1,100)

1.34s CURRENT-SNAPSHOT

1.42s LAST-SNAPSHOT

1.33s PHOENIX-1.1

1.33s PHOENIX-1.2.0

select count(core) from INDEXED_TEST_TABLE_LARGE where core IN (1,25,50,75,100)

0.31s CURRENT-SNAPSHOT

0.31s LAST-SNAPSHOT

1.36s PHOENIX-1.1

1.39s PHOENIX-1.2.0

select /*+NO_INDEX*/ count(core) from INDEXED_TEST_TABLE_LARGE where core IN (1,25,50,75,100)

1.38s CURRENT-SNAPSHOT

1.46s LAST-SNAPSHOT

1.38s PHOENIX-1.1

1.36s PHOENIX-1.2.0

select count(core) from INDEXED_TEST_TABLE_LARGE where core < 10 and db < 200

1.07s CURRENT-SNAPSHOT

1.14s LAST-SNAPSHOT

1.74s PHOENIX-1.1

1.71s PHOENIX-1.2.0

select /*+NO_INDEX*/ count(core) from INDEXED_TEST_TABLE_LARGE where core < 10 and db < 200

1.78s CURRENT-SNAPSHOT

1.78s LAST-SNAPSHOT

1.71s PHOENIX-1.1

1.71s PHOENIX-1.2.0

select count(core) from INDEXED_TEST_TABLE_LARGE where core < 50 and db < 1000

1.56s CURRENT-SNAPSHOT

1.66s LAST-SNAPSHOT

2.54s PHOENIX-1.1

2.5s PHOENIX-1.2.0

select /*+NO_INDEX*/ count(core) from INDEXED_TEST_TABLE_LARGE where core < 50 and db < 1000

2.72s CURRENT-SNAPSHOT

2.67s LAST-SNAPSHOT

2.58s PHOENIX-1.1

2.55s PHOENIX-1.2.0

select count(core) from INDEXED_TEST_TABLE_LARGE where core < 100 and db < 2000

1.88s CURRENT-SNAPSHOT

2s LAST-SNAPSHOT

4.22s PHOENIX-1.1

4.16s PHOENIX-1.2.0

select /*+NO_INDEX*/ count(core) from INDEXED_TEST_TABLE_LARGE where core < 100 and db < 2000

4.5s CURRENT-SNAPSHOT

4.3s LAST-SNAPSHOT

4.26s PHOENIX-1.1

4.21s PHOENIX-1.2.0

select count(core) from INDEXED_TEST_TABLE_LARGE where core < 10 and active_visitor < 1000

1.08s CURRENT-SNAPSHOT

1.15s LAST-SNAPSHOT

2.67s PHOENIX-1.1

1.36s PHOENIX-1.2.0

select /*+NO_INDEX*/ count(core) from INDEXED_TEST_TABLE_LARGE where core < 10 and active_visitor < 1000

1.42s CURRENT-SNAPSHOT

1.38s LAST-SNAPSHOT

2.66s PHOENIX-1.1

1.34s PHOENIX-1.2.0

select count(core) from INDEXED_TEST_TABLE_LARGE where core < 50 and active_visitor < 5000

1.6s CURRENT-SNAPSHOT

1.72s LAST-SNAPSHOT

3.27s PHOENIX-1.1

1.38s PHOENIX-1.2.0

select /*+NO_INDEX*/ count(core) from INDEXED_TEST_TABLE_LARGE where core < 50 and active_visitor < 5000

1.48s CURRENT-SNAPSHOT

1.42s LAST-SNAPSHOT

3.23s PHOENIX-1.1

1.41s PHOENIX-1.2.0

select count(core) from INDEXED_TEST_TABLE_LARGE where core < 100 and active_visitor < 10000

1.83s CURRENT-SNAPSHOT

1.91s LAST-SNAPSHOT

4.49s PHOENIX-1.1

1.4s PHOENIX-1.2.0

select /*+NO_INDEX*/ count(core) from INDEXED_TEST_TABLE_LARGE where core < 100 and active_visitor < 10000

1.57s CURRENT-SNAPSHOT

1.45s LAST-SNAPSHOT

4.41s PHOENIX-1.1

1.41s PHOENIX-1.2.0

select count(core) from INDEXED_TEST_TABLE_LARGE where core > 90

1.27s CURRENT-SNAPSHOT

1.35s LAST-SNAPSHOT

1.48s PHOENIX-1.1

1.44s PHOENIX-1.2.0

select /*+NO_INDEX*/ count(core) from INDEXED_TEST_TABLE_LARGE where core > 90

1.54s CURRENT-SNAPSHOT

1.53s LAST-SNAPSHOT

1.48s PHOENIX-1.1

1.42s PHOENIX-1.2.0

select count(core) from INDEXED_TEST_TABLE_LARGE where core > 50

1.4s CURRENT-SNAPSHOT

1.51s LAST-SNAPSHOT

2.05s PHOENIX-1.1

1.99s PHOENIX-1.2.0

select /*+NO_INDEX*/ count(core) from INDEXED_TEST_TABLE_LARGE where core > 50

2.18s CURRENT-SNAPSHOT

2.13s LAST-SNAPSHOT

2.05s PHOENIX-1.1

2.14s PHOENIX-1.2.0

select count(core) from INDEXED_TEST_TABLE_LARGE where core > 0

1.6s CURRENT-SNAPSHOT

1.7s LAST-SNAPSHOT

2.75s PHOENIX-1.1

2.73s PHOENIX-1.2.0

select /*+NO_INDEX*/ count(core) from INDEXED_TEST_TABLE_LARGE where core > 0

2.9s CURRENT-SNAPSHOT

2.78s LAST-SNAPSHOT

2.76s PHOENIX-1.1

2.69s PHOENIX-1.2.0

select db from INDEXED_TEST_TABLE_LARGE where db >5 and db <10 order by db

0.25s CURRENT-SNAPSHOT

0.24s LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

select /*+NO_INDEX*/ db from INDEXED_TEST_TABLE_LARGE where db >5 and db <10 order by db

2.7s CURRENT-SNAPSHOT

2.6s LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

select db from INDEXED_TEST_TABLE_LARGE_test_table order by db limit 100

N/A for CURRENT-SNAPSHOT

N/A for LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

select /*+NO_INDEX*/ db from INDEXED_TEST_TABLE_LARGE_test_table order by db limit 100

N/A for CURRENT-SNAPSHOT

N/A for LAST-SNAPSHOT

N/A for PHOENIX-1.1

N/A for PHOENIX-1.2.0

LOAD DATA [8000000 ROWS]

1103.85s CURRENT-SNAPSHOT

1077.78s LAST-SNAPSHOT

348.82s PHOENIX-1.1

391.01s PHOENIX-1.2.0

CF_TABLE_14CF
Data is split in 14 column families. Phoenix 1.2+ uses Essential Column Family filter feature which fetches only required columns when filtering rows.

ROWS 4000000 [4M]

DDL CREATE TABLE IF NOT EXISTS $TABLE (K1 CHAR(1) NOT NULL, K2 VARCHAR NOT NULL, CF1.A INTEGER, CF2.B INTEGER, CF3.C INTEGER, CF4.D INTEGER, CF5.E INTEGER, CF6.F INTEGER, CF7.G INTEGER, CF8.H INTEGER, CF9.I INTEGER, CF10.J INTEGER, CF11.K INTEGER, CF12.L INTEGER, CF13.M INTEGER, CF14.N INTEGER CONSTRAINT PK PRIMARY KEY (K1,K2)) SPLIT ON ('B','C','D')

DATA GENERATOR
STRING :: Values: A|B|C|D
STRING :: Length: 10 Values: SEQUENTIAL
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM

QUERIES

select count(1) from CF_TABLE_14CF where K1 in ('A', 'B', 'C', 'D')

3.41s CURRENT-SNAPSHOT

3.5s LAST-SNAPSHOT

3.37s PHOENIX-1.1

3.4s PHOENIX-1.2.0

select count(1) from CF_TABLE_14CF where K1 in ('A', 'C')

3.22s CURRENT-SNAPSHOT

3.48s LAST-SNAPSHOT

3.25s PHOENIX-1.1

3.18s PHOENIX-1.2.0

select count(*) from CF_TABLE_14CF where N < 1000

1.75s CURRENT-SNAPSHOT

1.81s LAST-SNAPSHOT

4.93s PHOENIX-1.1

1.6s PHOENIX-1.2.0

select a,b,c,d,e,f,g,h,i,j,k,l,m,n from CF_TABLE_14CF where (B>1000 and B<2000) and (M>1000 and M<2000)

2.41s CURRENT-SNAPSHOT

2.45s LAST-SNAPSHOT

129.97s PHOENIX-1.1

2.37s PHOENIX-1.2.0

select sum(a),sum(e),sum(j),sum(n) from CF_TABLE_14CF group by K1

10.4s CURRENT-SNAPSHOT

11.18s LAST-SNAPSHOT

10.48s PHOENIX-1.1

10.71s PHOENIX-1.2.0

LOAD DATA [4000000 ROWS]

205.67s CURRENT-SNAPSHOT

207.36s LAST-SNAPSHOT

195.08s PHOENIX-1.1

250.54s PHOENIX-1.2.0

SALTED_TABLE
This is Phoenix 1.2+ feature. Data is split in 4 regions equal to number of region servers in test cluster by adding salted byte to each key.

ROWS 4000000 [4M]

DDL CREATE TABLE $TABLE (K1 CHAR(1) NOT NULL, K2 VARCHAR NOT NULL, CFA.A VARCHAR, CFA.B CHAR(100), CFA.C INTEGER, CFB.D INTEGER CONSTRAINT PK PRIMARY KEY (K1,K2)) SALT_BUCKETS=4

DATA GENERATOR
STRING :: Values: A|B|C|D
STRING :: Length: 10 Values: SEQUENTIAL
STRING :: Length: 100 Values: RANDOM
STRING :: Length: 100 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM

QUERIES

select count(1) from SALTED_TABLE where K1 in ('A', 'B', 'C', 'D')

1.96s CURRENT-SNAPSHOT

1.8s LAST-SNAPSHOT

6s PHOENIX-1.1

1.89s PHOENIX-1.2.0

select count(*) from SALTED_TABLE where D < 1000

0.95s CURRENT-SNAPSHOT

1.01s LAST-SNAPSHOT

7.74s PHOENIX-1.1

0.88s PHOENIX-1.2.0

select avg(c),avg(d) from SALTED_TABLE group by K1

4.07s CURRENT-SNAPSHOT

4.45s LAST-SNAPSHOT

11.54s PHOENIX-1.1

4.09s PHOENIX-1.2.0

LOAD DATA [4000000 ROWS]

130.7s CURRENT-SNAPSHOT

130.11s LAST-SNAPSHOT

179.65s PHOENIX-1.1

157.03s PHOENIX-1.2.0

CF_TABLE_1CF
Same data as in 14 column family table but this one only has a single column family. Performance should be worse in most cases.

ROWS 4000000 [4M]

DDL CREATE TABLE IF NOT EXISTS $TABLE (K1 CHAR(1) NOT NULL, K2 VARCHAR NOT NULL, CF.A INTEGER, CF.B INTEGER, CF.C INTEGER, CF.D INTEGER, CF.E INTEGER, CF.F INTEGER, CF.G INTEGER, CF.H INTEGER, CF.I INTEGER, CF.J INTEGER, CF.K INTEGER, CF.L INTEGER, CF.M INTEGER, CF.N INTEGER CONSTRAINT PK PRIMARY KEY (K1,K2)) SPLIT ON ('B','C','D')

DATA GENERATOR
STRING :: Values: A|B|C|D
STRING :: Length: 10 Values: SEQUENTIAL
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM
INTEGER :: Max. Value: 1000000 Values: RANDOM

QUERIES

select count(1) from CF_TABLE_1CF where K1 in ('A', 'B', 'C', 'D')

4.15s CURRENT-SNAPSHOT

4.18s LAST-SNAPSHOT

4.22s PHOENIX-1.1

4.24s PHOENIX-1.2.0

select count(1) from CF_TABLE_1CF where K1 in ('A', 'C')

4.15s CURRENT-SNAPSHOT

4.17s LAST-SNAPSHOT

4.21s PHOENIX-1.1

4.22s PHOENIX-1.2.0

select count(*) from CF_TABLE_1CF where N < 1000

5.66s CURRENT-SNAPSHOT

5.62s LAST-SNAPSHOT

5.45s PHOENIX-1.1

5.63s PHOENIX-1.2.0

select a,b,c,d,e,f,g,h,i,j,k,l,m,n from CF_TABLE_1CF where B>1000 and B<2000 and M>1000 and M<2000

6.57s CURRENT-SNAPSHOT

6.71s LAST-SNAPSHOT

25.24s PHOENIX-1.1

6.8s PHOENIX-1.2.0

select sum(a),sum(e),sum(j),sum(n) from CF_TABLE_1CF group by K1

12.02s CURRENT-SNAPSHOT

12.38s LAST-SNAPSHOT

12.13s PHOENIX-1.1

12.18s PHOENIX-1.2.0

LOAD DATA [4000000 ROWS]

173.68s CURRENT-SNAPSHOT

173.6s LAST-SNAPSHOT

164.63s PHOENIX-1.1

218.71s PHOENIX-1.2.0

Note: Hover over version label to see Phoenix Query Explain Plan.