Re: How to get table/column statistics

2023-03-03 Thread Jian Chen
Thank you Alex, But I just try on my local, see the sys.STATISTICS_GLOBAL_DATA table empty while sys.STATISTICS_LOCAL_DATA contains the actual statistics, is it as expected? Yours Sincerely Stephen Jian Chen 于2023年3月3日周五 16:56写道: > wow that’s cool > > Alex Plehanov 于2023年3月3日 周五下午4:55写道: > >>

Re: How to get table/column statistics

2023-03-03 Thread Jian Chen
wow that’s cool Alex Plehanov 于2023年3月3日 周五下午4:55写道: > Jian Chen, > > There is such a view as STATISTICS_GLOBAL_DATA, but looks like it isn't > documented. > > пт, 3 мар. 2023 г. в 11:13, Jian Chen : > > > Hi Igniters, > > > > I am trying to get table statistics for a Ignite table, find the docum

Re: How to get table/column statistics

2023-03-03 Thread Alex Plehanov
Jian Chen, There is such a view as STATISTICS_GLOBAL_DATA, but looks like it isn't documented. пт, 3 мар. 2023 г. в 11:13, Jian Chen : > Hi Igniters, > > I am trying to get table statistics for a Ignite table, find the document > in > > https://ignite.apache.org/docs/latest/monitoring-metrics/sy

How to get table/column statistics

2023-03-03 Thread Jian Chen
Hi Igniters, I am trying to get table statistics for a Ignite table, find the document in https://ignite.apache.org/docs/latest/monitoring-metrics/system-views#statistics_local_data My question is: Is there any way to get the table/column complete statistics rather than the local data on one node