"Js" <js*******@yahoo.com> wrote in message
news:ca**************************@posting.google.c om...
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