Shulou(Shulou.com)06/01 Report--

70F3: 100 * (Required Pages / Total Pages) > 80SCHEMA NAME CARD OV NP FP ACTBLK TSIZE F1 F2 F3 REORG -W2 PPANELDB 5381266 0 5e+06 5e+06-2.27e+10 0 51 100-*- -Index statistics:F4: CLUSTERRATIO or normalized CLUSTERFACTOR > 80F5: 100 * (KEYS * (ISIZE + 9) + (CARD-KEYS) * 5) / ((NLEAF-NUM EMPTY LEAFS) * INDEXPAGESIZE) > 50F6: (100-PCTFREE) * ((INDEXPAGESIZE-96) / (ISIZE + 12)) * * (NLEVELS-2) * (INDEXPAGESIZE-96) / (KEYS * (ISIZE + 9) + (CARD-KEYS) * 5) < 100F7: 100 * (NUMRIDS DELETED / (NUMRIDS DELETED + CARD)) < 20F8: 100 * (NUM EMPTY LEAFS / NLEAF) < 20SCHEMA NAME CARD LEAF ELEAF LVLS ISIZE NDEL KEYS F4 F5 F6 F7 F8 REORG -- Table: W2.PPANELDBSYSIBM SQL160501093122750 5e+06 24215 0 3 14 0 5e+06 4228 62 100-W2 PPANELDB_INDEX1 5e+06 4228 0 3 7 0 13 100 77 11 00-W2 PPANELDB_INDEX10 5e+06 4119 0 3 15 0 30870 100 81 700-W2 PPANELDB_INDEX11 5e+06 5853 0 3 15 0 711172 100 84 500-W2 PPANELDB_INDEX12 5e+06 4119 0 3 11 0 3750 79 9 00-W2 PPANELDB_INDEX13 5e+06 3971 0 3 21 0625 100 82 60 0 0-W2 PPANELDB_INDEX14 5e+06 4111 0 3 11 02 100 79 9 00-W2 PPANELDB_INDEX15 5e+06 4111 0 3 11 02 100 79 9 00-W2 PPANELDB_INDEX16 5e+06 4102 0 3 13 0 12438 100 80 800-W2 PPANELDB_INDEX17 5e+06 4101 0 3 13 0 11809 100 80 800-W2 PPANELDB_INDEX18 5e+06 4082 0 3 13 0 3604 100 80 800-W2 PPANELDB_INDEX19 5e+06 4112 0 3 11 0 270 100 79 9 00-W2 PPANELDB_INDEX2 5e+06 4316 0 3 5 0 8 100 76 12 00-W2 PPANELDB_INDEX20 5e+06 4228 0 3 7 0 16 100 77 11 00-W2 PPANELDB_INDEX21 5e+06 4079 0 3 13 0 1974 80 800-W2 PPANELDB_INDEX22 5e+06 4164 0 3 9 0741 100 78 1000-W2 PPANELDB_INDEX23 5e+06 48857 0 4 106 0 3e+06 10088 9 00-W2 PPANELDB_INDEX24 5e+06 3920 0 3 31 0 2998 100 84 500-W2 PPANELDB_INDEX25 5e+06 9984 0 3 11 0 3e+06 100 87 3 00-W2 PPANELDB_INDEX26 5e+06 4210 0 3 13 0 59807 100 80 800-W2 PPANELDB_INDEX3 5e+06 4519 0 3 20 1 100 72 15 00-W2 PPANELDB_INDEX4 5e+06 4228 0 3 7 0 65 100 77 11 00-W2 PPANELDB_INDEX5 5e+06 4090 0 3 12 0 2 100 80 9 00-W2 PPANELDB_INDEX6 5e+06 4316 0 3 50 0 2 100 76 12 00-W2 PPANELDB_INDEX7 5e+06 4228 0 3 7 0 69 100 77 11 00-W2 PPANELDB_INDEX8 5e+06 4115 0 3 11 0 1771 100 79 9 00-W2 PPANELDB_INDEX9 5e+06 4228 0 3 7 0 2 100 77 11 00 CLUSTERRATIO or normalized CLUSTERFACTOR (F4) will indicate REORG is necessaryfor indexes that are not in the same sequence as the base table. When multipleindexes are defined on a table, one or more indexes may be flagged as needingREORG. Specify the most important index for REORG sequencing.Tables defined using the ORGANIZE BY clause and the corresponding dimensionindexes have a'* 'suffix to their names. The cardinality of a dimension indexis equal to the Active blocks statistic of the table.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.