Archives of the TeradataForum
Message Posted: Thu, 07 Sep 2001 @ 00:46:08 GMT
Another query that can be used is:
Select databasename, tablename, sum(currentperm) from dbc.tables a dbc.tablesize b where a.databasename = b.databasename and a.tablename = b.tablename group by 1,2;
This query will include the space used by all secondary indexes as well as the table itself.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|