calculate size of idx

From: Kommareddy, Srinivas (MED, Wissen Infotech) <Srinivas.Kommareddy_at_med.ge.com>
Date: Mon, 16 Feb 2004 22:36:03 -0600
Message-ID: <1C9727B12F498543A43CBB988F30515C023499EB@uswaumsx14medge.med.ge.com>

Hi Lists,  

We are going to perform a data load to a table.  

To calculate the space required for n rows for a table we use avg_row_len*n rows from dba_tables.
But how we can do that for indexes ?  

B'coz my table has 7 indexes which are built on 10 different columns. I want to add space to index tablespace also... (most of the indexes columns are NUMBER, should I take 32 bytes * n rows to calculate the size )  

Thanks and Regards,
Srinivas    

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Mon Feb 16 2004 - 22:36:03 CST