Index Organized Tables

  • From: Sanjay Mishra <sanjay_mishra0@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 16 Jun 2008 23:25:45 -0700 (PDT)

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;


      

Other related posts: