Re: Index Space Usage more than Data Space Usage

On Tue, 10 Sep 2002 11:37:55 GMT, "Joe Sath" <dbadba62_at_hotmail.com> wrote:

>If you delete a lot of data, the entry in index will not be deleted, that is
>why index will take more space than the data it self.

Nope.
If you delete a lot of rows in a table, the table itself will not shrink either (unless you truncate). So deleting a lot of data in a table will not itself cause an index to be bigger than the table.

>Alter index rebuild will solve the problem.

Not necessarily. Also depends on the storage parameters you give the index.

• Kenneth Koenraadt

>"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
>news:unr42ln5g5cjfc_at_corp.supernews.com...
>>
>> "Ora" <ora_geek_at_yahoo.com> wrote in message
>> news:fa5d6718.0209092108.7cacba74_at_posting.google.com...
>> > I administer an OLTP database.
>> >
>> > I have separate tablespaces on different Disk for Table data and index
>> > Objetcts .
>> >
>> > FOr one Module, the Space used in Index Tablespace is almost double
>> > than that of the corresponding Data Tablespace.
>> >
>> > Is it possible that Index objects occupy such large space vis-a-visa
>> > its Table Data ?
>> >
>> > OrA
>>
>> This is quite normal
>>
>> Hth
>>
>>
>> --
>> Sybrand Bakker
>> Senior Oracle DBA
>>
>> to reply remove '-verwijderdit' from my e-mail address
>>
>>
>>
>
>
Received on Tue Sep 10 2002 - 06:54:19 CDT