How to get table size in splice machine?

Question

82 views Asked by Nisha Tamta At 21 June 2019 at 05:39

I am not able to fetch the size of my table in Splice Machine database.

This view SYS.SYSTABLESTATISTICS is not returning any value. However i have tables and data in those tables.

Select * from SYS.SYSTABLESTATISTICS;

I expect the output to be the size of tables.

There are 1 answers

**Bob Baran** · Accepted Answer · 2019-06-21 21:17:43

Bob Baran On 21 June 2019 at 21:17 BEST ANSWER

Have you run analyze on your table? Need to run this for there to be data in systablstatistics.