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>


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

Original text of this message