SET CHARWIDTH 100
SELECT A.TABLE_NAME || CHR( 9 ) || 
       A.INDEX_NAME || CHR( 9 ) || CHR( 9 ) || CHR( 9 ) || 
       COUNT(B.COLUMN_POSITION) || CHR( 9 ) || 
       SUM( DECODE( C.DATA_TYPE, 'NUMBER', DATA_PRECISION, DATA_LENGTH ) ) || CHR( 9 ) || 
       MAX( A.NUM_ROWS) || CHR(9) ||
       MAX( D.BLOCKS)
       "Dados dos Indices"
FROM   DBA_INDEXES A, 
       DBA_IND_COLUMNS B, 
       DBA_TAB_COLUMNS C,
       DBA_SEGMENTS D
WHERE  A.TABLE_OWNER = B.TABLE_OWNER
AND    A.TABLE_NAME  = B.TABLE_NAME
AND    A.INDEX_NAME  = B.INDEX_NAME
AND    B.TABLE_OWNER = C.OWNER
AND    B.TABLE_NAME  = C.TABLE_NAME
AND    B.COLUMN_NAME = C.COLUMN_NAME
AND    A.TABLE_OWNER = 'ESTCAND2000'
AND    A.OWNER       = D.OWNER
AND    A.INDEX_NAME  = D.SEGMENT_NAME
GROUP  BY A.TABLE_NAME, A.INDEX_NAME;