"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 Sun Sep 12 2004 - 20:29:01 CDT
