Home -> Usenet -> comp.databases.theory -> Data fragmentation into DB ORACLE

Data fragmentation into DB ORACLE

From: Giulio Samaritano <giulio.samaritano_at_tlt.alcatel.it>
Date: Fri, 16 Mar 2001 15:45:01 +0100
Message-ID: <3AB226EC.8DF77374_at_tlt.alcatel.it> 






Hi all


I have this problem due to excessive slow report production:



    
  
  1.   data fragmentation inside the DB;






  For it someone suggested me to introduce some INDEX for
  the critical table into the DB (this to improve performance) or to
reduce fragmentation


  executing a DB export and a DB import (this operation would improve
the data


  positioning inside the DB,


  reorganizing data for efficient storage and performance).



Are both operations correct? If yes , I have to execute both or is
itnecessary only one?



Thanks in advance


Giulio Samaritano
Received on Fri Mar 16 2001 - 15:45:01 CET












Original text of this message