hi, check this link, talk about why index need to be rebuild http://www.dbazine.com/oracle/or-articles/jlewis14
--- Pada Sen, 12/10/09, Moch Firman N <[email protected]> menulis: Dari: Moch Firman N <[email protected]> Judul: Re: [indo-oracle] Index Rebuilding vs Index Recreating Kepada: [email protected] Tanggal: Senin, 12 Oktober, 2009, 1:41 PM 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] Yahoo! Mail Kini Lebih Cepat dan Lebih Bersih. Rasakan bedanya sekarang! http://id.mail.yahoo.com [Non-text portions of this message have been removed]
