Re: Reorg von secundary indexesGeschrieben von Gernot Ruban on Dezember 29, 2001 um 15:38: Als Antwort auf Re: Reorg von secundary indexes geschrieben von Gernot Ruban on Dezember 29, 2001 um 15:37:
Formula F4: The clustering ratio of an index should be greater than 80 percent. When multiple indexes are defined on one table, some of these indexes have a low cluster ratio. (The index sequence is not the same as the table sequence.) This cannot be avoided. Be sure to specify the most important index when reorganizing the table. The cluster ratio is usually not optimal for indexes that contain many duplicate keys and many entries.
Antworten:
|