Tip : How can i find size of table in firebird?
You get an approximate value by running gstat and then check out the
Data pages value for the table. Multiply that value with your database page size. This is the allocated space on disk.
You get an approximate value by running gstat and then check out the
Data pages value for the table. Multiply that value with your database page size. This is the allocated space on disk.
You must be logged in to post a comment.
Or, you can just use IBAnalyst, to simple see tables and indices size in pages, megabytes, etc. 🙂
I think it would be more interesting to show how to do this in SQL.
IMHO tools like gstat and gsec should be replaced by SQL commands