Re: Index Space Usage more than Data Space Usage

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 10 Sep 2002 08:16:29 +0200
Message-ID: <unr42ln5g5cjfc@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 - 01:16:29 CDT