Re: Cluster index oddities
Since TRUNCATE TABLE is internally implemented as DROP/CREATE it will DROP/CREATE all indexes on the table as well. The indexes will be empty though so in this case nothing to rebuild.
Subject
Views
Written By
Posted
1101
November 14, 2017 11:05AM
557
November 15, 2017 07:32AM
540
November 15, 2017 08:32AM
496
November 15, 2017 12:44PM
536
November 15, 2017 08:44AM
507
November 15, 2017 12:50PM
Re: Cluster index oddities
445
December 12, 2017 05:58AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.