Mujtaba Chohan created PHOENIX-2724:
---------------------------------------
Summary: Query with large number of guideposts is slower compared
to no stats
Key: PHOENIX-2724
URL: https://issues.apache.org/jira/browse/PHOENIX-2724
Project: Phoenix
Issue Type: Bug
Affects Versions: 4.7.0
Environment: Phoenix 4.7.0-RC4, HBase-0.98.17 on a 8 node cluster
Reporter: Mujtaba Chohan
With 1MB guidepost width for ~900GB/500M rows table. Queries with short scan
range gets significantly slower.
Without stats:
{code}
select * from T limit 10; // query execution time <100 msec
{code}
With stats:
{code}
select * from T limit 10; // query execution time >20 seconds
Explain plan: CLIENT 876085-CHUNK 476569382 ROWS 876060986727 BYTES SERIAL
1-WAY FULL SCAN OVER T SERVER 10 ROW LIMIT CLIENT 10 ROW LIMIT
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
