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]
