Wah ini bahasanya sophisticated banget. Apa bedanya ya antara Index Rebuilding dengan Index Recreating.? Can you please tell me what is the different between those two and what do you mean by Index Recreating?
One thing for sure Index Rebuilding is only needed when your index is corrupted. How to identify when Index is corrupted, that will be a different story. thanks ----- Original Message ----- From: Moch Firman N To: [email protected] Sent: Monday, October 12, 2009 2:41 AM 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 <[email protected]> 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 <[email protected] <mochfirman%40gmail.com>> > To: [email protected] <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] ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.421 / Virus Database: 270.14.9/2428 - Release Date: 10/11/09 06:39:00 [Non-text portions of this message have been removed]
