Index Quality

Column leaves format 99999999999999999999 Column net_mb format 999999999999 Column gross_mb format 999999999999 Set Lines 200 — Modify as you require the page size set pages 5000 Spool index_stat.txt SELECT INDEX_NAME, NUM_ROWS, ROWLEN, LEAVES, NET_MB, GROSS_MB, QUALITY FROM ( SELECT I.INDEX_NAME INDEX_NAME, I.NUM_ROWS NUM_ROWS, SUM(TC.AVG_COL_LEN + 1) + 7 ROWLEN, I.LEAF_BLOCKS LEAVES, ROUND((SUM(TC.AVG_COL_LEN + 1) + …