Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> does "truncate table" affect the performace of the associated indexes?

does "truncate table" affect the performace of the associated indexes?

From: Cantonese Boy <waynewan_at_yahoo.com>
Date: Fri, 21 Dec 2001 15:07:34 +0800
Message-ID: <3C22DFB6.BC06AED@yahoo.com> 





Hi,



I have a table which needed to be truncated and re-import data
everyday. Do I needed to rebuild the associated indexes to 
get a better perfermance after each "truncate"?
(Will there any performance problem


in the indexes tablespace)



Thanks for any help



W.
Received on Fri Dec 21 2001 - 01:07:34 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US