Xref: alice comp.databases.oracle.misc:30488
Message-ID: <373002D9.A7EF258F@adr.it>
Date: Wed, 05 May 1999 10:35:37 +0200
From: Francesco Dini <dini.f@adr.it>
X-Mailer: Mozilla 4.06 [en] (WinNT; I)
MIME-Version: 1.0
Subject: Re: Fragmentation question.
References: <7gagpa$1ia$1@emu.cs.rmit.edu.au>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: comp.databases.oracle.misc
Lines: 20
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!news-ge.switch.ch!serra.unipi.it!news.caspur.it!news.uni.net

I think that horizontal fragmentation is that inside the row of a table: if a row is often updated it is possible for it to raise the problem of migration and chaining. I think that horizontal fragmentation is concerned about these two problems.

Abhimanyu Parasher wrote:

> Hi!
>    Thanks for reading this. I need an urgent help to understand the concept of data fragmentation in the case of ORACLE.
>
> What does Horizontal fragmentation mean in the case of ORACLE? Does it mean that we hold separate copies of fragmented tables in different databases ? Because, if it is like that then the constraint policy of Primary key wouldn't hold good on such kind of data.
> So, what actually it means ?
>
> Please reply asap.
>
> Thanks
>
> Abhimanyu Parasher
>
> --
>
>
>

