If you rebuild with ALTER INDEX xxx REBUILD there are very good chances you will get a new index consisting of the same number and same sizes of extents as your original index have had. Yo have to provide new storage parameters for an index if fragmentation is what you are fighting against.
Use something like:
ALTER INDEX xxx STORAGE (INITIAL xM NEXT xM PCTINCREASE0) REBUILD NOLOGGING;
Jurij Modic ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
If I extract the DDL for what I have now it looks like:
Alter Index FNDRYR0200.CAT_ID_NAME_IX Rebuild
This is what the storage is at present. Any pointers as to what I should use to determine what the correct initial and next should be?
Use SAFE(Simple Algorithm for Fragmentation Elimination) rules for your indexes also to avoid fragmentation. You can change your initial extent size for index without dropping and recreating it unlike for tables. Give appropriate size based on the size of the index tablespace for initial and next with PCTINCREASE 0 for Index tablespace. I hope you have read SAFE rules to avoid fragmentation. Search for PDF documnet here in this forum. You have bunch of posts on that.