Archives of the TeradataForum
Message Posted: Mon, 20 Oct 2003 @ 15:16:21 GMT
There is no designation of separate index space with Teradata. Indices are actually subtables which are considered part of the main table. The quickest to get a summary of the space that a particular table is currently using is to do the following:
SELECT TableName, SUM(CurrentPerm) AS CurrentPerm, SUM(PeakPerm) AS PeakPerm FROM Dbc.TableSize WHERE DatabaseName='eu_dev_edw' AND TableName='copa' GROUP BY 1;
If you want to do an entire set of tables in a database, you can remove the "AND TableName" clause and add an "ORDER BY 1". Of course you could also get rid of the database and do a "LIKE" to see the same table (or set of tables) across all databases. But there is no way to tell the amount of space for a particular index from the database catalog (dbc tables). I will pass this inquiry on to the Teradata listserv and see if they know a way.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|