Data fragmentation into DB ORACLE

From: Giulio Samaritano <giulio.samaritano_at_tlt.alcatel.it>
Date: Fri, 16 Mar 2001 15:44:31 +0100
Message-ID: <3AB226CE.545019A9_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:44:31 CET

Original text of this message