In message <1166109023.164657.84250_at_l12g2000cwl.googlegroups.com>,
EscVector <Junk_at_webthere.com> writes
>I've seen this a few times since getting into Warehousing, but I need a
>sanity check.
>
>How often has anyone seen the total INDEX bytes exceed DATA bytes,
>meaning I have more data stored in standard indexes, not index
>organized tables, than regular heap tables.
>
It is not unusual.
Given the rowid overhead in an index, if the table is quite narrow a
single index could easily be larger than the table. If you have multiple
indexes the total index space could be several times the size of the
table.
--
Jim Smith
Ponder Stibbons Limited <http://oracleandting.blogspot.com/>
RSS <http://oracleandting.blogspot.com/atom.xml>
Received on Thu Dec 14 2006 - 09:19:54 CST
