Re: Index Organize Tables
From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Mon, 13 Sep 2004 01:29:01 GMT
Message-ID: <xJ61d.80050$3l3.33875_at_attbi_s03>
Date: Mon, 13 Sep 2004 01:29:01 GMT
Message-ID: <xJ61d.80050$3l3.33875_at_attbi_s03>
"Js" <js_oracle_at_yahoo.com> wrote in message
news:ca1f82c7.0409121438.57a5df35_at_posting.google.com...
> hi all,
>
> I want to know ..
>
> I read about IOT's in ORACLE Docs .. But Still I am confused .. when
one
> should use IOT tables ..
>
>
> Thanks,
> Js
Good for lookup tables that are accessed by the primary key.
Good for colocating information that you are going to look up by most of the
primary key. The typical example is stock prices where you have ticker
symbol, date, price.
Jim
Received on Mon Sep 13 2004 - 03:29:01 CEST