Re: Index based database?

From: EscVector <Junk_at_webthere.com>
Date: 14 Dec 2006 07:29:32 -0800
Message-ID: <1166110172.104499.291490@80g2000cwy.googlegroups.com>

The tables are not narrow.
Example 27 col table has 26 single column indexes.

Still normal?

Jim Smith wrote:
> 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:29:32 CST