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>
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:
- 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