Forever growing indexes problem
From: Barry Roomberg <barry.roomberg_at_compudata.com>
Date: Sun, 3 Apr 94 16:45:00 -0500
Message-ID: <12a.429.905.0N3E0AD5_at_compudata.com>
Date: Sun, 3 Apr 94 16:45:00 -0500
Message-ID: <12a.429.905.0N3E0AD5_at_compudata.com>
-> Shutting the system down, dropping the indexes, and recreating will
-> result in smaller indexes.
->
-> Question does anybody have any thoughts on how to fix this problem?
-> We are still running Version 6 but would upgrade to Version 7 if it
-> would help.
Nope. The only O7 does like that is resizing rollback segments to optimum size.
You may want to play with the STORAGE params to slow the process down, but sooner or later you will be extending those indexes! Received on Sun Apr 03 1994 - 23:45:00 CEST