hi, I think recreate almost same with create new index. When recreate index, first step is drop index and create again.
Base on my experience rebuild index more faster then create/recreate on table with partition or not. ________________________________ From: Moch Firman N <[email protected]> To: [email protected] Sent: Mon, October 12, 2009 1:41:36 PM Subject: Re: [indo-oracle] Index Rebuilding vs Index Recreating Halo Sandi, Thanks for your reply.... Friendly remind that I am talking about re-create index not create index. Best regards Piping On Mon, Oct 12, 2009 at 12:02 PM, murdi santoso <sandi...@yahoo. com> wrote: > > > Hi, > > rebuild index need when index in status invalid (check status in > all_indexes) > and create index need when you don't have index in your table and that > table is big and always use in query. > > ____________ _________ _________ __ > From: Moch Firman N <mochfir...@gmail. com <mochfirman% 40gmail.com> > > To: indo-oracle@ yahoogroups. com <indo-oracle% 40yahoogroups. com> > Sent: Mon, October 12, 2009 11:52:40 AM > Subject: [indo-oracle] Index Rebuilding vs Index Recreating > > > Dear All, > > Any one knows when we should rebuild the index? And when we should recreate > the index? > > What is the actual parameter of those ? > > Thanks and best regards > > Piping > > [Non-text portions of this message have been removed] > > ____________ _________ _________ _________ _________ __ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail. yahoo.com > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
