Re: Local Index Size

  • From: Peter Hitchman <pjhoraclel@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 10 Jul 2012 20:12:45 +0100

It is not unheard of for an index to be larger than a table or a table
partition, if it includes most of the table columns, because it also
has to store a rowed with each index entry. Do you have the original
SQL used to create the indexes as well as the tables?


On Tue, Jul 10, 2012 at 5:04 PM, Jonathan Lewis
<jonathan@xxxxxxxxxxxxxxxxxx> wrote:
> It seems extremely unlikely (though not totally impossible) that Oracle
> should have done something so bizarre.
> Which version of Oracle
> What does the DDL for the tablespace the index partitions are in look like
> ?
> What are the default settings (dba_part_indexes) for the index ?
> What does a call to dbms_metadata.get_ddl tell you about the index
> definition ?
> Regards
> Jonathan Lewis
> Author: Oracle Core (Apress 2011)

Other related posts: