I would like to initiate a rebuilding index task in our Production Database. Just want to verify:
Does issue this is OK for each table:
alter index I_INDIVIDUAL_SURNAME rebuild unrecoverable tablespace NS_BIG_INDEXES
/
what will happen to first and next extent sizes? Do I need to add Storage parameter to better organize the indexes?
Is it possible the performance degrade instead of boost?
can I run the script during working hours?
Any other consideration? It is a mission critical production DB 8.0 on Win NT and its about 20 GB.
An ounce of prevention is worth a pound of cure