Index Organized Tables

From: Sanjay Mishra <sanjay_mishra0_at_yahoo.com>
Date: Mon, 16 Jun 2008 23:25:45 -0700 (PDT)
Message-ID: <658498.33194.qm@web33807.mail.mud.yahoo.com>


I am looking for some practical guidance on IOT (Index Organized Tables). Oracle has steadily enhanced them over the releases since they were first introduced. What is the biggest IOT you have seen? Should one consider to design a large fact table (&gt; 300 GB) in a data warehouse application as an IOT? What are the implications / considerations?
&nbsp;

Thanks,
Sanjay&nbsp;
&nbsp;
&nbsp;
      

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jun 17 2008 - 01:25:45 CDT

Original text of this message