Pular para o conteúdo

› Fóruns › Banco de dados Oracle › Rebuil de Index › Rebuil de Index

2 de abril de 2007 às 9:21 pm #79146
chduarte
Participante

    O Note:1019722.6 no metalink é um script completo para verificar fragmentacao do indice.

    Segue como “regra”:

    In the following cases, it may be worthwhile to rebuild the index:
    –> the percentage of the space used is bad – lower than 66%: PCT_USED
    –> deleted leaf blocks represent more than 20% of total leaf blocks: DEL_LF_ROWS
    –> the height of the tree is bigger than 3: HEIGHT or BLEVEL

    []