Mohammed Abdul Afroze

• Nov 1st, 2007

 

It improves space utilization by removing deleted entries.And it can be rebuild with minimum table locking.

Syntax:sql>alter index<index name> rebuild online;