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>
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 (> 300 GB) in a data warehouse application as an IOT? What are the implications / considerations?
Thanks,
Sanjay
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 17 2008 - 01:25:45 CDT