using dbc.tablesize, determine total tablesize for...
We are currently deploying a new user interface and navigational structure on our Community. These design changes align with our new Teradata Access portal and provide a more cohesive experience for our users.
Re: using dbc.tablesize, determine total tablesize for a specific user
The information in DBC.TableSize is maintained for all tables and is not affected in any way by the use of "collect statistics".
This query will show the disk space used by each table you have created.
select databasename, tablename, sum(currentperm) from dbc.tablesize a where exists (select 1 from dbc.tables b where a.databasename = b.databasename and a.tablename = b.tablename and b.creatorname = user) group by 1, 2;
Omit the group by clause if you want only the grand total.