Re: How a row is physical stored in Oracle
From: Michael Austin <maustin_at_firstdbasource.com>
Date: Sun, 07 Sep 2008 10:08:40 -0500
Message-ID: <b8Swk.21746$89.2485@nlpi069.nbdc.sbc.com>
>> I was just curious to know rows are physically stored for a table in
>> Oracle database. Are they stored by Primary Key? If I don't want to
>> store them by primary key but some other column, how will I be able to
>> do it.
>>
>> I would appreciate if someone can point me to some documentation and
>> few good reference books.
>>
>> My background is in SQL Server and I am pretty much aware of its
>> internals. I would like to do the same with Oracle. I would appreciate
>> your help on the books and links.
Date: Sun, 07 Sep 2008 10:08:40 -0500
Message-ID: <b8Swk.21746$89.2485@nlpi069.nbdc.sbc.com>
Noons wrote:
> Najm Hashmi wrote,on my timestamp of 8/09/2008 12:33 AM: >
>> I was just curious to know rows are physically stored for a table in
>> Oracle database. Are they stored by Primary Key? If I don't want to
>> store them by primary key but some other column, how will I be able to
>> do it.
>>
>> I would appreciate if someone can point me to some documentation and
>> few good reference books.
>>
>> My background is in SQL Server and I am pretty much aware of its
>> internals. I would like to do the same with Oracle. I would appreciate
>> your help on the books and links.
> > Start here: > http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/toc.htm > then follow up as needed from here: > http://www.oracle.com/pls/db102/portal.portal_db?selected=3 > If it asks you to register at any stage, do: it's free, no spam.
More specifically:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/logical.htm#sthref283
Bottom line is that you don't get to say how they are stored. You can only tell it which tablespace (which can consist of multiple datafiles) and how you want it accessed. PK for accessing by PK and any other index for accessing it by that indexed column definition or full table scan if no index exists. Received on Sun Sep 07 2008 - 10:08:40 CDT