RE: Re: Index rebuilds

From: Diana Duncan <Diana_at_fileFRENZY.com>
Date: Thu, 5 Oct 2000 12:49:52 -0400
Message-Id: <10640.118612@fatcity.com>

You don't have to do either. The index becomes empty when the table in truncated, then is filled up again when the data is inserted. If you feel the index has become unbalanced, use the alter index rebuild command.

Diana

-----Original Message-----
From: cemail_at_sprintmail.com [mailto:cemail_at_sprintmail.com] Sent: Thursday, October 05, 2000 11:52 AM To: Multiple recipients of list ORACLE-L 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 - 11:49:52 CDT