Yes you can. If you are repopulating the tables every day then the indexes
will be rebuilt by this process. Unless you are making many changes during
the day you won't have to rebuild them at all.
HTH,
Ruth
----- Original Message -----
From: <cemail_at_sprintmail.com>
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Thursday, October 05, 2000 11:52 AM
Subject: RE: Re: Index rebuilds
>
> I guess my question should have been, can you use alter index
> rebuild or do you have to drop and then recreate the index?
> --- Original Message ---
> "Ruth Gramolini" <rgramolini_at_tax.state.vt.us> Wrote on
> Thu, 05 Oct 2000 05:35:50 -0800
> ------------------
> There was a discussion about this in the past couple of weeks.
> When a table
> is trucated the index is empty . You have to rebuild the index
> after the
> table is poplated.
> HTH,
> Ruth
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, October 04, 2000 9:50 PM
>
>
> >
> > Oracle 8.0.5. Can index rebuilds be used on a table that has
> > been truncated and reloaded? In other words, we have a table
> > and then we truncate it and load it with much of the same data,
> > except more data (don't ask me why they do it this way). Can
> > we have an index, truncate the table, then just do a rebuild?
> > We want to be able to save time with the indexes and also
> be
> > able to change storage parameters.
> >
> > -----
> > Sent using MailStart.com ( http://MailStart.Com/welcome.html
> )
> > The FREE way to access your mailbox via any web browser, anywhere!
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> > INET: cemail_at_sprintmail.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858)
> 538-5051
> > San Diego, California -- Public Internet access / Mailing
> Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
> and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).
> You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ruth Gramolini
> INET: rgramolini_at_tax.state.vt.us
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing
> Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
> and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You
> may
> also send the HELP command for other information (like subscribing).
>
>
>
> -----
> Sent using MailStart.com ( http://MailStart.Com/welcome.html )
> The FREE way to access your mailbox via any web browser, anywhere!
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: cemail_at_sprintmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Thu Oct 05 2000 - 12:07:55 CDT
