Database Tuning (MOSC)

MOSC Banner

Alter index shrink space vs alter index rebuild?

edited May 20, 2009 9:40PM in Database Tuning (MOSC) 7 commentsAnswered
 Hi all,

My segment advisors recommend that i shrink space for an index. When I analyze my index using my own script (check for percentage of deleted rows and the height), it shows that i should perform a rebuild for the index.

Now, I am confuse between the below:

(1) alter index XXX shrink space

(2) alter index XXX rebuild.

What is the differences between the 2 and which should i peform first?

Help needed urgently! Thanks in advance.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center