How to get table size in splice machine?

Question

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.

score 2 · Accepted Answer · answered Jun 21 '19 at 21:17

2

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

answered Jun 21 '19 at 21:17

Bob Baran

thank you. that helped. i was able to get the table size after analyzing the table. – Nisha Tamta Jul 03 '19 at 05:11

1 Answers1