Archives of the TeradataForum

Message Posted: Thu, 16 Mar 2006 @ 19:28:39 GMT

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

> Try this:

          > SELECT
          >    SUM(a.CurrentPerm)
          >   ,b.DataBaseName
          >   ,b.TableName
          >   ,b.ColumnName
          > FROM
          >    DBC.TableSize a, DBC.Indices b
          > WHERE
          >    a.DatabaseName = b.DataBaseName
          > AND
          >    a.TableName    = b.TableName
          > AND
          >    b.IndexType = 'S'
          > AND
          >    b.UniqueFlag = 'N'
          > GROUP BY
          >    b.DataBaseName
          >   ,b.TableName
          >   ,b.ColumnName
          > ORDER BY
          >    SUM(A.CurrentPerm) DESC
          >   ,b.ColumnName ASC
          >   ,b.TableName ASC
          >   ,b.DataBaseName ASC
          > ;

I don't think this will calculate NUSI size.

Victor

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