Index Organize Tables

#1

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

#2

"Js" <js_oracle (AT) yahoo (DOT) com> wrote

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Index Organize Tables

comp.databases.oracle comp.databases.oracle

Index Organize Tables - 09-12-2004 , 05:38 PM

Re: Index Organize Tables - 09-12-2004 , 08:29 PM