Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Index based database?

Re: Index based database?

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 14 Dec 2006 10:26:03 -0800
Message-ID: <1166120762.475382@bubbleator.drizzle.com>


EscVector wrote:

> 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>

Please don't top post. Scroll to the bottom to reply.

Given that this is a warehouse it may be fine and it may be excessive.

Is is a "real" warehouse designed as one or just a copy of an OLTP schema? Are they being used?
What index type?
What version of Oracle?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Dec 14 2006 - 12:26:03 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US