Title: RE: Speed up Truncate tables - rebuild index
Yes,
the point of my message was simply a quick reminder to rebuild the indexes on a
table that has been ALTER TABLE...MOVE moved.
I
havent tested this, but I believe Lisa is right, in part, if the table is
truncated, then moved, then
I think that the reference to "build the indexes" referres to the moving of the table
and not the truncating. I believe that the indexes become invalid after for move a
table and have to be rebuild. Oracle looses the "link" to the tables location when it
is moved. Like someone moving your car w
Title: RE: Speed up Truncate tables - rebuild index
Ahhh... Thank you. Pre-coffee over here.
LK
-Original Message-
From: Igor Neyman [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, August 16, 2001 12:58 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Speed up
Title: RE: Speed up Truncate tables - rebuild index
Lisa,
I think Chris referred to 'alter table ... move',
in which case you need to rebuild indexes (ROWIDs
changed).
Igor Neyman, OCP DBAPerceptron, Inc.(734)414-4627[EMAIL PROTECTED]
- Original Message -
From
Title: RE: Speed up Truncate tables - rebuild index
Actually Chris if you truncate a table, the indexes on the table are truncated right along with it. You don't end up with a sparse index, like when you delete many rows. Try it. I did (8.1.6) and was very happy to see this beh