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

Home -> Community -> 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@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 - 08:45:01 CST

Original text of this message

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