Re: Indexed Tablespace Fragmentation

From: Mike Borden <tilwenbr_at_netscape.net>
Date: 29 Apr 2002 06:13:01 -0700
Message-ID: <8a41a7df.0204290513.2da71f7e@posting.google.com>

Ok, I got it a lot better now. I rebuilt the indexes with the initial extent the size of the whole index, and after every rebuild I coalesced the tablespace. The coalescing, I know takes up CPU, but there wasn't a lot of activity at the time I did it.

I really can't use locally managed tablespace, cause the indexes don't all grow at the same rate. This is a vendor supplied schema, so they put the names of the indexes and tables into tablespaces that have names that relate to those tables and indexes.

Thanks for the help. Received on Mon Apr 29 2002 - 08:13:01 CDT