Apache Phoenix Performance Result :: Wed Mar 19 10:26:22 PDT 2014

---

Queries by Category

---

Index

select count(*) from INDEXED_TABLE 0.51s PHOENIX-3C20EF2 0.68s PHOENIX-SNAPSHOT

select /*+ INDEX(INDEXED_TABLE idx1 idx2 idx3 idx4) */ count(*) from INDEXED_TABLE 0.78s PHOENIX-3C20EF2 0.8s PHOENIX-SNAPSHOT

select /*+ INDEX(INDEXED_TABLE ids1 ids2 ids3 ids4) */ count(*) from INDEXED_TABLE 0.29s PHOENIX-3C20EF2 0.25s PHOENIX-SNAPSHOT

select /*+NO_INDEX*/ count(*) from INDEXED_TABLE 0.93s PHOENIX-3C20EF2 0.82s PHOENIX-SNAPSHOT

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 PHOENIX-3C20EF2 0.21s PHOENIX-SNAPSHOT

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), host 1.5s PHOENIX-3C20EF2 1.49s PHOENIX-SNAPSHOT

select count(core) from INDEXED_TABLE where core IN (1,100) 0.13s PHOENIX-3C20EF2 0.1s PHOENIX-SNAPSHOT

select /*+ INDEX(INDEXED_TABLE idx1 idx2 idx3 idx4) */ count(core) from INDEXED_TABLE where core IN (1,100) 0.04s PHOENIX-3C20EF2 0.04s PHOENIX-SNAPSHOT

select /*+ INDEX(INDEXED_TABLE ids1 ids2 ids3 ids4) */ count(core) from INDEXED_TABLE where core IN (1,100) 0.09s PHOENIX-3C20EF2 0.09s PHOENIX-SNAPSHOT

select /*+NO_INDEX*/ count(core) from INDEXED_TABLE where core IN (1,100) 1.12s PHOENIX-3C20EF2 1.15s PHOENIX-SNAPSHOT

select count(core) from INDEXED_TABLE where core IN (1,25,50,75,100) 0.13s PHOENIX-3C20EF2 0.12s PHOENIX-SNAPSHOT

select /*+ INDEX(INDEXED_TABLE idx1 idx2 idx3 idx4) */ count(core) from INDEXED_TABLE where core IN (1,25,50,75,100) 0.1s PHOENIX-3C20EF2 0.1s PHOENIX-SNAPSHOT

select /*+ INDEX(INDEXED_TABLE ids1 ids2 ids3 ids4) */ count(core) from INDEXED_TABLE where core IN (1,25,50,75,100) 0.07s PHOENIX-3C20EF2 0.11s PHOENIX-SNAPSHOT

select /*+NO_INDEX*/ count(core) from INDEXED_TABLE where core IN (1,25,50,75,100) 1.17s PHOENIX-3C20EF2 1.09s PHOENIX-SNAPSHOT

select count(core) from INDEXED_TABLE where core < 10 and db < 200 0.22s PHOENIX-3C20EF2 0.21s PHOENIX-SNAPSHOT

select /*+ INDEX(INDEXED_TABLE idx1 idx2 idx3 idx4) */ count(core) from INDEXED_TABLE where core < 10 and db < 200 0.64s PHOENIX-3C20EF2 0.68s PHOENIX-SNAPSHOT

select /*+ INDEX(INDEXED_TABLE ids1 ids2 ids3 ids4) */ count(core) from INDEXED_TABLE where core < 10 and db < 200 0.17s PHOENIX-3C20EF2 0.17s PHOENIX-SNAPSHOT

select /*+NO_INDEX*/ count(core) from INDEXED_TABLE where core < 10 and db < 200 1.44s PHOENIX-3C20EF2 1.34s PHOENIX-SNAPSHOT

select count(core) from INDEXED_TABLE where core < 100 and db < 2000 0.5s PHOENIX-3C20EF2 0.48s PHOENIX-SNAPSHOT

select /*+NO_INDEX*/ count(core) from INDEXED_TABLE where core < 100 and db < 2000 1.75s PHOENIX-3C20EF2 1.63s PHOENIX-SNAPSHOT

select count(core) from INDEXED_TABLE where core > 90 0.15s PHOENIX-3C20EF2 0.14s PHOENIX-SNAPSHOT

select /*+NO_INDEX*/ count(core) from INDEXED_TABLE where core > 90 1.23s PHOENIX-3C20EF2 1.23s PHOENIX-SNAPSHOT

select count(core) from INDEXED_TABLE where core > 0 0.44s PHOENIX-3C20EF2 0.41s PHOENIX-SNAPSHOT

select /*+NO_INDEX*/ count(core) from INDEXED_TABLE where core > 0 1.33s PHOENIX-3C20EF2 1.26s PHOENIX-SNAPSHOT

select db from INDEXED_TABLE where db >5 and db <7 order by db 0.14s PHOENIX-3C20EF2 0.1s PHOENIX-SNAPSHOT

select /*+NO_INDEX*/ db from INDEXED_TABLE where db >5 and db <7 order by db 2.13s PHOENIX-3C20EF2 2.22s PHOENIX-SNAPSHOT

select db from INDEXED_TABLE order by db limit 10 0.08s PHOENIX-3C20EF2 0.08s PHOENIX-SNAPSHOT

select /*+NO_INDEX*/ db from INDEXED_TABLE order by db limit 10 1.67s PHOENIX-3C20EF2 1.61s PHOENIX-SNAPSHOT

select count(*) from INDEXED_TABLE_MUTABLE 0.92s PHOENIX-3C20EF2 0.95s PHOENIX-SNAPSHOT

select /*+ INDEX(INDEXED_TABLE_MUTABLE midx1 midx2 midx3 midx4) */ count(*) from INDEXED_TABLE_MUTABLE 1.08s PHOENIX-3C20EF2 0.98s PHOENIX-SNAPSHOT

select /*+ INDEX(INDEXED_TABLE_MUTABLE mids1 mids2 mids3 mids4) */ count(*) from INDEXED_TABLE_MUTABLE 0.53s PHOENIX-3C20EF2 0.48s PHOENIX-SNAPSHOT

select /*+NO_INDEX*/ count(*) from INDEXED_TABLE_MUTABLE 0.78s PHOENIX-3C20EF2 1s PHOENIX-SNAPSHOT

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.37s PHOENIX-3C20EF2 0.36s PHOENIX-SNAPSHOT

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.37s PHOENIX-3C20EF2 1.56s PHOENIX-SNAPSHOT

select count(core) from INDEXED_TABLE_MUTABLE where core IN (1,100) 0.15s PHOENIX-3C20EF2 0.14s PHOENIX-SNAPSHOT

select /*+ INDEX(INDEXED_TABLE_MUTABLE midx1 midx2 midx3 midx4) */ count(core) from INDEXED_TABLE_MUTABLE where core IN (1,100) 0.04s PHOENIX-3C20EF2 0.04s PHOENIX-SNAPSHOT

select /*+ INDEX(INDEXED_TABLE_MUTABLE mids1 mids2 mids3 mids4) */ count(core) from INDEXED_TABLE_MUTABLE where core IN (1,100) 0.13s PHOENIX-3C20EF2 0.12s PHOENIX-SNAPSHOT

select /*+NO_INDEX*/ count(core) from INDEXED_TABLE_MUTABLE where core IN (1,100) 1s PHOENIX-3C20EF2 1.18s PHOENIX-SNAPSHOT

select count(core) from INDEXED_TABLE_MUTABLE where core IN (1,25,50,75,100) 0.16s PHOENIX-3C20EF2 0.15s PHOENIX-SNAPSHOT

select /*+ INDEX(INDEXED_TABLE_MUTABLE midx1 midx2 midx3 midx4) */ count(core) from INDEXED_TABLE_MUTABLE where core IN (1,25,50,75,100) 0.08s PHOENIX-3C20EF2 0.11s PHOENIX-SNAPSHOT

select /*+ INDEX(INDEXED_TABLE_MUTABLE mids1 mids2 mids3 mids4) */ count(core) from INDEXED_TABLE_MUTABLE where core IN (1,25,50,75,100) 0.14s PHOENIX-3C20EF2 0.12s PHOENIX-SNAPSHOT

select /*+NO_INDEX*/ count(core) from INDEXED_TABLE_MUTABLE where core IN (1,25,50,75,100) 1.01s PHOENIX-3C20EF2 1.16s PHOENIX-SNAPSHOT

select count(core) from INDEXED_TABLE_MUTABLE where core < 10 and db < 200 0.43s PHOENIX-3C20EF2 0.42s PHOENIX-SNAPSHOT

select /*+ INDEX(INDEXED_TABLE_MUTABLE midx1 midx2 midx3 midx4) */ count(core) from INDEXED_TABLE_MUTABLE where core < 10 and db < 200 0.41s PHOENIX-3C20EF2 0.4s PHOENIX-SNAPSHOT

select /*+ INDEX(INDEXED_TABLE_MUTABLE mids1 mids2 mids3 mids4) */ count(core) from INDEXED_TABLE_MUTABLE where core < 10 and db < 200 0.42s PHOENIX-3C20EF2 0.41s PHOENIX-SNAPSHOT

select /*+NO_INDEX*/ count(core) from INDEXED_TABLE_MUTABLE where core < 10 and db < 200 1.27s PHOENIX-3C20EF2 1.39s PHOENIX-SNAPSHOT

select count(core) from INDEXED_TABLE_MUTABLE where core < 100 and db < 2000 1.08s PHOENIX-3C20EF2 0.92s PHOENIX-SNAPSHOT

select /*+NO_INDEX*/ count(core) from INDEXED_TABLE_MUTABLE where core < 100 and db < 2000 1.6s PHOENIX-3C20EF2 1.62s PHOENIX-SNAPSHOT

select count(core) from INDEXED_TABLE_MUTABLE where core > 90 0.19s PHOENIX-3C20EF2 0.18s PHOENIX-SNAPSHOT

select /*+NO_INDEX*/ count(core) from INDEXED_TABLE_MUTABLE where core > 90 1.09s PHOENIX-3C20EF2 1.26s PHOENIX-SNAPSHOT

select count(core) from INDEXED_TABLE_MUTABLE where core > 0 0.59s PHOENIX-3C20EF2 0.54s PHOENIX-SNAPSHOT

select /*+NO_INDEX*/ count(core) from INDEXED_TABLE_MUTABLE where core > 0 1.23s PHOENIX-3C20EF2 1.33s PHOENIX-SNAPSHOT

select db from INDEXED_TABLE_MUTABLE where db >5 and db <7 order by db 0.22s PHOENIX-3C20EF2 0.21s PHOENIX-SNAPSHOT

select /*+NO_INDEX*/ db from INDEXED_TABLE_MUTABLE where db >5 and db <7 order by db 2.02s PHOENIX-3C20EF2 2.25s PHOENIX-SNAPSHOT

select db from INDEXED_TABLE_MUTABLE order by db limit 10 1.28s PHOENIX-3C20EF2 1.41s PHOENIX-SNAPSHOT

select /*+NO_INDEX*/ db from INDEXED_TABLE_MUTABLE order by db limit 10 1.5s PHOENIX-3C20EF2 1.76s PHOENIX-SNAPSHOT

---

Index Creation After Data

CREATE INDEX idx5 ON INDEXED_TABLE (CORE) INCLUDE (DB,ACTIVE_VISITOR) 31.05s PHOENIX-3C20EF2 36.78s PHOENIX-SNAPSHOT

CREATE INDEX midx5 ON INDEXED_TABLE_MUTABLE (CORE) INCLUDE (DB,ACTIVE_VISITOR) 36.76s PHOENIX-3C20EF2 38.65s PHOENIX-SNAPSHOT

---

Load Data

LOAD DATA INDEXED_TABLE [2000000 ROWS] 446.53s PHOENIX-3C20EF2 452.97s PHOENIX-SNAPSHOT

LOAD DATA INDEXED_TABLE_MUTABLE [2000000 ROWS] 650.88s PHOENIX-3C20EF2 720.44s PHOENIX-SNAPSHOT

---

Queries by Table

---

INDEXED_TABLE

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

ROWS 2000000 [2M]

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 idx1 ON $TABLE (CORE);CREATE INDEX idx2 ON $TABLE (DB);CREATE INDEX idx3 ON $TABLE (DB,ACTIVE_VISITOR);CREATE INDEX idx4 ON $TABLE (CORE,DB,ACTIVE_VISITOR);CREATE INDEX ids1 ON $TABLE (CORE) SALT_BUCKETS=16;CREATE INDEX ids2 ON $TABLE (DB) SALT_BUCKETS=16;CREATE INDEX ids3 ON $TABLE (DB,ACTIVE_VISITOR) SALT_BUCKETS=16;CREATE INDEX ids4 ON $TABLE (CORE,DB,ACTIVE_VISITOR) SALT_BUCKETS=16;

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

select count(*) from INDEXED_TABLE 0.51s PHOENIX-3C20EF2 0.68s PHOENIX-SNAPSHOT

select /*+ INDEX(INDEXED_TABLE idx1 idx2 idx3 idx4) */ count(*) from INDEXED_TABLE 0.78s PHOENIX-3C20EF2 0.8s PHOENIX-SNAPSHOT

select /*+ INDEX(INDEXED_TABLE ids1 ids2 ids3 ids4) */ count(*) from INDEXED_TABLE 0.29s PHOENIX-3C20EF2 0.25s PHOENIX-SNAPSHOT

select /*+NO_INDEX*/ count(*) from INDEXED_TABLE 0.93s PHOENIX-3C20EF2 0.82s PHOENIX-SNAPSHOT

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 PHOENIX-3C20EF2 0.21s PHOENIX-SNAPSHOT

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), host 1.5s PHOENIX-3C20EF2 1.49s PHOENIX-SNAPSHOT

select count(core) from INDEXED_TABLE where core IN (1,100) 0.13s PHOENIX-3C20EF2 0.1s PHOENIX-SNAPSHOT

select /*+ INDEX(INDEXED_TABLE idx1 idx2 idx3 idx4) */ count(core) from INDEXED_TABLE where core IN (1,100) 0.04s PHOENIX-3C20EF2 0.04s PHOENIX-SNAPSHOT

select /*+ INDEX(INDEXED_TABLE ids1 ids2 ids3 ids4) */ count(core) from INDEXED_TABLE where core IN (1,100) 0.09s PHOENIX-3C20EF2 0.09s PHOENIX-SNAPSHOT

select /*+NO_INDEX*/ count(core) from INDEXED_TABLE where core IN (1,100) 1.12s PHOENIX-3C20EF2 1.15s PHOENIX-SNAPSHOT

select count(core) from INDEXED_TABLE where core IN (1,25,50,75,100) 0.13s PHOENIX-3C20EF2 0.12s PHOENIX-SNAPSHOT

select /*+ INDEX(INDEXED_TABLE idx1 idx2 idx3 idx4) */ count(core) from INDEXED_TABLE where core IN (1,25,50,75,100) 0.1s PHOENIX-3C20EF2 0.1s PHOENIX-SNAPSHOT

select /*+ INDEX(INDEXED_TABLE ids1 ids2 ids3 ids4) */ count(core) from INDEXED_TABLE where core IN (1,25,50,75,100) 0.07s PHOENIX-3C20EF2 0.11s PHOENIX-SNAPSHOT

select /*+NO_INDEX*/ count(core) from INDEXED_TABLE where core IN (1,25,50,75,100) 1.17s PHOENIX-3C20EF2 1.09s PHOENIX-SNAPSHOT

select count(core) from INDEXED_TABLE where core < 10 and db < 200 0.22s PHOENIX-3C20EF2 0.21s PHOENIX-SNAPSHOT

select /*+ INDEX(INDEXED_TABLE idx1 idx2 idx3 idx4) */ count(core) from INDEXED_TABLE where core < 10 and db < 200 0.64s PHOENIX-3C20EF2 0.68s PHOENIX-SNAPSHOT

select /*+ INDEX(INDEXED_TABLE ids1 ids2 ids3 ids4) */ count(core) from INDEXED_TABLE where core < 10 and db < 200 0.17s PHOENIX-3C20EF2 0.17s PHOENIX-SNAPSHOT

select /*+NO_INDEX*/ count(core) from INDEXED_TABLE where core < 10 and db < 200 1.44s PHOENIX-3C20EF2 1.34s PHOENIX-SNAPSHOT

select count(core) from INDEXED_TABLE where core < 100 and db < 2000 0.5s PHOENIX-3C20EF2 0.48s PHOENIX-SNAPSHOT

select /*+NO_INDEX*/ count(core) from INDEXED_TABLE where core < 100 and db < 2000 1.75s PHOENIX-3C20EF2 1.63s PHOENIX-SNAPSHOT

select count(core) from INDEXED_TABLE where core > 90 0.15s PHOENIX-3C20EF2 0.14s PHOENIX-SNAPSHOT

select /*+NO_INDEX*/ count(core) from INDEXED_TABLE where core > 90 1.23s PHOENIX-3C20EF2 1.23s PHOENIX-SNAPSHOT

select count(core) from INDEXED_TABLE where core > 0 0.44s PHOENIX-3C20EF2 0.41s PHOENIX-SNAPSHOT

select /*+NO_INDEX*/ count(core) from INDEXED_TABLE where core > 0 1.33s PHOENIX-3C20EF2 1.26s PHOENIX-SNAPSHOT

select db from INDEXED_TABLE where db >5 and db <7 order by db 0.14s PHOENIX-3C20EF2 0.1s PHOENIX-SNAPSHOT

select /*+NO_INDEX*/ db from INDEXED_TABLE where db >5 and db <7 order by db 2.13s PHOENIX-3C20EF2 2.22s PHOENIX-SNAPSHOT

select db from INDEXED_TABLE order by db limit 10 0.08s PHOENIX-3C20EF2 0.08s PHOENIX-SNAPSHOT

select /*+NO_INDEX*/ db from INDEXED_TABLE order by db limit 10 1.67s PHOENIX-3C20EF2 1.61s PHOENIX-SNAPSHOT

CREATE INDEX idx5 ON INDEXED_TABLE (CORE) INCLUDE (DB,ACTIVE_VISITOR) 31.05s PHOENIX-3C20EF2 36.78s PHOENIX-SNAPSHOT

LOAD DATA INDEXED_TABLE [2000000 ROWS] 446.53s PHOENIX-3C20EF2 452.97s PHOENIX-SNAPSHOT

---

INDEXED_TABLE_MUTABLE

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

ROWS 2000000 [2M]

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)) MAX_FILESIZE=30485760;CREATE INDEX midx1 ON $TABLE (CORE);CREATE INDEX midx2 ON $TABLE (DB);CREATE INDEX midx3 ON $TABLE (DB,ACTIVE_VISITOR);CREATE INDEX midx4 ON $TABLE (CORE,DB,ACTIVE_VISITOR);CREATE INDEX mids1 ON $TABLE (CORE) SALT_BUCKETS=16;CREATE INDEX mids2 ON $TABLE (DB) SALT_BUCKETS=16;CREATE INDEX mids3 ON $TABLE (DB,ACTIVE_VISITOR) SALT_BUCKETS=16;CREATE INDEX mids4 ON $TABLE (CORE,DB,ACTIVE_VISITOR) SALT_BUCKETS=16;

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

select count(*) from INDEXED_TABLE_MUTABLE 0.92s PHOENIX-3C20EF2 0.95s PHOENIX-SNAPSHOT

select /*+ INDEX(INDEXED_TABLE_MUTABLE midx1 midx2 midx3 midx4) */ count(*) from INDEXED_TABLE_MUTABLE 1.08s PHOENIX-3C20EF2 0.98s PHOENIX-SNAPSHOT

select /*+ INDEX(INDEXED_TABLE_MUTABLE mids1 mids2 mids3 mids4) */ count(*) from INDEXED_TABLE_MUTABLE 0.53s PHOENIX-3C20EF2 0.48s PHOENIX-SNAPSHOT

select /*+NO_INDEX*/ count(*) from INDEXED_TABLE_MUTABLE 0.78s PHOENIX-3C20EF2 1s PHOENIX-SNAPSHOT

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.37s PHOENIX-3C20EF2 0.36s PHOENIX-SNAPSHOT

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.37s PHOENIX-3C20EF2 1.56s PHOENIX-SNAPSHOT

select count(core) from INDEXED_TABLE_MUTABLE where core IN (1,100) 0.15s PHOENIX-3C20EF2 0.14s PHOENIX-SNAPSHOT

select /*+ INDEX(INDEXED_TABLE_MUTABLE midx1 midx2 midx3 midx4) */ count(core) from INDEXED_TABLE_MUTABLE where core IN (1,100) 0.04s PHOENIX-3C20EF2 0.04s PHOENIX-SNAPSHOT

select /*+ INDEX(INDEXED_TABLE_MUTABLE mids1 mids2 mids3 mids4) */ count(core) from INDEXED_TABLE_MUTABLE where core IN (1,100) 0.13s PHOENIX-3C20EF2 0.12s PHOENIX-SNAPSHOT

select /*+NO_INDEX*/ count(core) from INDEXED_TABLE_MUTABLE where core IN (1,100) 1s PHOENIX-3C20EF2 1.18s PHOENIX-SNAPSHOT

select count(core) from INDEXED_TABLE_MUTABLE where core IN (1,25,50,75,100) 0.16s PHOENIX-3C20EF2 0.15s PHOENIX-SNAPSHOT

select /*+ INDEX(INDEXED_TABLE_MUTABLE midx1 midx2 midx3 midx4) */ count(core) from INDEXED_TABLE_MUTABLE where core IN (1,25,50,75,100) 0.08s PHOENIX-3C20EF2 0.11s PHOENIX-SNAPSHOT

select /*+ INDEX(INDEXED_TABLE_MUTABLE mids1 mids2 mids3 mids4) */ count(core) from INDEXED_TABLE_MUTABLE where core IN (1,25,50,75,100) 0.14s PHOENIX-3C20EF2 0.12s PHOENIX-SNAPSHOT

select /*+NO_INDEX*/ count(core) from INDEXED_TABLE_MUTABLE where core IN (1,25,50,75,100) 1.01s PHOENIX-3C20EF2 1.16s PHOENIX-SNAPSHOT

select count(core) from INDEXED_TABLE_MUTABLE where core < 10 and db < 200 0.43s PHOENIX-3C20EF2 0.42s PHOENIX-SNAPSHOT

select /*+ INDEX(INDEXED_TABLE_MUTABLE midx1 midx2 midx3 midx4) */ count(core) from INDEXED_TABLE_MUTABLE where core < 10 and db < 200 0.41s PHOENIX-3C20EF2 0.4s PHOENIX-SNAPSHOT

select /*+ INDEX(INDEXED_TABLE_MUTABLE mids1 mids2 mids3 mids4) */ count(core) from INDEXED_TABLE_MUTABLE where core < 10 and db < 200 0.42s PHOENIX-3C20EF2 0.41s PHOENIX-SNAPSHOT

select /*+NO_INDEX*/ count(core) from INDEXED_TABLE_MUTABLE where core < 10 and db < 200 1.27s PHOENIX-3C20EF2 1.39s PHOENIX-SNAPSHOT

select count(core) from INDEXED_TABLE_MUTABLE where core < 100 and db < 2000 1.08s PHOENIX-3C20EF2 0.92s PHOENIX-SNAPSHOT

select /*+NO_INDEX*/ count(core) from INDEXED_TABLE_MUTABLE where core < 100 and db < 2000 1.6s PHOENIX-3C20EF2 1.62s PHOENIX-SNAPSHOT

select count(core) from INDEXED_TABLE_MUTABLE where core > 90 0.19s PHOENIX-3C20EF2 0.18s PHOENIX-SNAPSHOT

select /*+NO_INDEX*/ count(core) from INDEXED_TABLE_MUTABLE where core > 90 1.09s PHOENIX-3C20EF2 1.26s PHOENIX-SNAPSHOT

select count(core) from INDEXED_TABLE_MUTABLE where core > 0 0.59s PHOENIX-3C20EF2 0.54s PHOENIX-SNAPSHOT

select /*+NO_INDEX*/ count(core) from INDEXED_TABLE_MUTABLE where core > 0 1.23s PHOENIX-3C20EF2 1.33s PHOENIX-SNAPSHOT

select db from INDEXED_TABLE_MUTABLE where db >5 and db <7 order by db 0.22s PHOENIX-3C20EF2 0.21s PHOENIX-SNAPSHOT

select /*+NO_INDEX*/ db from INDEXED_TABLE_MUTABLE where db >5 and db <7 order by db 2.02s PHOENIX-3C20EF2 2.25s PHOENIX-SNAPSHOT

select db from INDEXED_TABLE_MUTABLE order by db limit 10 1.28s PHOENIX-3C20EF2 1.41s PHOENIX-SNAPSHOT

select /*+NO_INDEX*/ db from INDEXED_TABLE_MUTABLE order by db limit 10 1.5s PHOENIX-3C20EF2 1.76s PHOENIX-SNAPSHOT

CREATE INDEX midx5 ON INDEXED_TABLE_MUTABLE (CORE) INCLUDE (DB,ACTIVE_VISITOR) 36.76s PHOENIX-3C20EF2 38.65s PHOENIX-SNAPSHOT

LOAD DATA INDEXED_TABLE_MUTABLE [2000000 ROWS] 650.88s PHOENIX-3C20EF2 720.44s PHOENIX-SNAPSHOT

---

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