Re: Index Organized tables: Please explain use?

In My Humble Opinion

Terry

Hannah.M.Doran_at_sb.com wrote:

> Michael,
>
> Ok, A stupid question now: IMH ( and newbie) O, I'm afraid I didn't get to this
> acronym in my trial by fire training:> or was that sink or swim training?
>
> Thanks,
>
> Hannah
>
> "Michael Ray" <Michael.Ray_at_trw.com> on 11/10/2000 01:18:32 PM
>
> Please respond to ORACLE-L_at_fatcity.com
>
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> cc:
>
> Hannah,
> You pretty much summed it up. The db maintains one b-tree structure that
> contains both the PK and the "extra" columns for each row. They are useful for
> frequent data access through the PK or a prefix of the PK. They take less
> storage and provide faster key-based access. To keep the b-tree densely
> clustered, you can keep non-key columns in an overflow area. IMH ( and newbie)
> O, that seems to be defeating the purpose of using an IOT. IOTs are not good for
> DML operations.
>
> Have fun with the "Bible".
>
> Michael Ray
> Oracle DBA
> TRW, Marshall, IL
> 217-826-3011 x2438
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Hannah.M.Doran_at_sb.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Fri Nov 10 2000 - 13:12:25 CST