Re: Statistics collection in Phoenix

2016-11-02 Thread Mich Talebzadeh
Thanks Sergey for clarification. Regards Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw * http://talebzadehmich.wordpress.com *Disclaimer:* Us

Re: Statistics collection in Phoenix

2016-11-02 Thread Sergey Soldatov
Hi Mich, The statistic is stored in SYSTEM.STATS table. And yes, there are guideposts per column family. As for (3) and (4) I think the answer is no. Guideposts are more like a point for specific row key (so if we scan for specific row key we can find quickly whether to start scanning) and let us r

Statistics collection in Phoenix

2016-10-30 Thread Mich Talebzadeh
According to document The UPDATE STATISTICS command updates the statistics collected on a table, to improve query performance. This command collects a set of keys per region per column family that are equal byte distanced from each other. These c