Re: How a row is physical stored in Oracle
From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Mon, 08 Sep 2008 20:13:19 +0200
Message-ID: <6il89vFq6ed5U1@mid.individual.net>
>
> Yeah, sometimes I tend to forget or overlook those as I can't get
> competent enough developers that will even consider them. Thanks for
> the reminder... (another concept from Rdb... :) )
Date: Mon, 08 Sep 2008 20:13:19 +0200
Message-ID: <6il89vFq6ed5U1@mid.individual.net>
On 08.09.2008 05:05, Michael Austin wrote:
> sybrandb_at_hccnet.nl wrote:
>> On Sun, 07 Sep 2008 10:08:40 -0500, Michael Austin >> <maustin_at_firstdbasource.com> wrote: >> >>> Bottom line is that you don't get to say how they are stored. >> >> This is only correct for heap tables. It is NOT correct for IOTs >>
>
> Yeah, sometimes I tend to forget or overlook those as I can't get
> competent enough developers that will even consider them. Thanks for
> the reminder... (another concept from Rdb... :) )
Also in clustered tables there will be some additional constraints where data is stored - depending on the way rows are inserted.
Kind regards
robert Received on Mon Sep 08 2008 - 13:13:19 CDT