Archives of the TeradataForum

Message Posted: Mon, 20 Oct 2003 @ 15:16:21 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hola Pierre,

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.

iv

	<Prev	Next>		<<First	<Prev	Next>	Last>>