[
https://issues.apache.org/jira/browse/PHOENIX-1693?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14345483#comment-14345483
]
Mujtaba Chohan commented on PHOENIX-1693:
-----------------------------------------
Sure James. I'll get more info. on this soon.
> Stats sometimes cause query to execute more slowly
> --------------------------------------------------
>
> Key: PHOENIX-1693
> URL: https://issues.apache.org/jira/browse/PHOENIX-1693
> Project: Phoenix
> Issue Type: Bug
> Reporter: Mujtaba Chohan
>
> After initial data load with Phoenix 4.3.0 with stats enabled for 500M FHA
> table using Pherf, aggregate count queries over 5% or 15% of total rows are
> some times 2-5X slow compared to queries without stats. Needs to investigate
> the root cause.
> Observations:
> * After major compaction with new stats are re-generated and queries become
> fast compared to tables without stats.
> * Trucating stats table after initial data load also makes queries perf.
> comparable to previous Phoenix release with stats disabled.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
