http://technet.oracle.com/docs/produ...dexes.htm#4443Quote:
Originally posted by ngwh
Hi ,
What is the different between using COALSE and REBUILD for Alter Index... ??
anyone can enlighten?
http://technet.oracle.com/docs/produ...dexes.htm#4443Quote:
Originally posted by ngwh
Hi ,
What is the different between using COALSE and REBUILD for Alter Index... ??
anyone can enlighten?
Coalesce doesn't need additional space (rebuild need the space for the "old index" and for the "new index" before dropping the old one)
Coalesce performs the rebuild of the index doing "partial commits" and "deleting partialy".
Cheers
Of course they will grow again. But why does my company pay me to be a DBA? To monitor indexes, growth patterns, index usage, etc. etc.
Rebuild is one of the things I have to do during off-peak hours, weekends etc.
On a production system, you just cannot ignore those holes in indexes which you are sure are important.
Nizar
hi,
also..what if i ENABLED the compression for Indexes ??
does it help to reduce the tablespace size??
Hope this clears your doubtsQuote:
Originally posted by nabaig
Of course they will grow again. But why does my company pay me to be a DBA? To monitor indexes, growth patterns, index usage, etc. etc.
Rebuild is one of the things I have to do during off-peak hours, weekends etc.
On a production system, you just cannot ignore those holes in indexes which you are sure are important.
Nizar
http://asktom.oracle.com/pls/ask/f?p...:457820220286,
Mr Tom Kyte who is a recognized Oracle expert recogns rebuild index is just another myth, waste of time :o
oh guess we were writing at the same time adewri :o
Hi Pando,
pardon my greenhorn-ness :) ...so if rebuilding index is wasting time..any suggestions given by him as to how we can manage the growth of indexes that eat up the tablespace? for my case the data are insertions and updates..so meaning if this is the operation pattern..my index tablespace for sure will "grow" right?
anyone correct me if I am wrong?
well the index freespace are reused you know... well considering if yo are inserting same range of values you deleted, but if you dont delete data then what´s the point?
Yes pando :)Quote:
Originally posted by pando
oh guess we were writing at the same time adewri :o
and NABAIG if you have been rebuilding your indexes with out using the NEXT clause. Then i think you must have ended using up more space than reducing it, just check the example Mr. TOM has given in his explanation... (Refer to link above)Quote:
Originally posted by nabaig
Of course they will grow again. But why does my company pay me to be a DBA? To monitor indexes, growth patterns, index usage, etc. etc.
Rebuild is one of the things I have to do during off-peak hours, weekends etc.
On a production system, you just cannot ignore those holes in indexes which you are sure are important.
Nizar
So i guess you are not getting paid correctly :)
(Just kidding)