HPL - Fragmented tables Q
Posted in 1998
Environment: HP/UX 10.10 7.23.UC4 Scenario: 55MM rec table fragmented by expression 65 times ( YR / WK ) rolling 65 weeks ( i.e.: every week oldest rolls off, new week loaded ) 6 indexes, attached, fragmented using the same fragmentation strategy We have a need to reload 26 weeks that were rolled off (and the need is "yesterday"). The standard process they use takes 7 - 9 hours -- I didn't set it up -- 6 indexes on the fragments when loaded. Now the question: Using HPL Express mode - disables the indexes, performs the load, and re-enables the indexes, adding the index entries for the inserted records. Does this restucture just the index of the fragement affected, or the entire index??? Thanks - Eric P. Melillo Associated Grocers, Inc.