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 -> Estimating index sizes

Estimating index sizes

From: Brian Rasmusson <br_at_belle.dk>
Date: 1997/12/12
Message-ID: <34913C2B.EA2C8DD2@belle.dk>#1/1

--------------1B38661E552FC8FFD82B6853
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi,

I would like to see the average record size of my indexes - is this possible?

When I use the ANALYZE command, i can see the average length of table rows in dba_tables, is simething similar available for indexes?

Regards,
Brian

--
------------------------------------------------------------------------
Brian Rasmusson, Software engineer & analyst        e-mail: br_at_belle.dk
Belle Systems A/S                                   web   : www.belle.dk
Network, Internet and communication specialists     phone : +45 59442500
------------------------------------------------------------------------



--------------1B38661E552FC8FFD82B6853
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit


<HTML>
Hi,
<P>I would like to see the average record size of my indexes - is this
possible?
<P>When I use the ANALYZE command, i can see the average length of table
rows in dba_tables, is simething similar available for indexes?
<P>Regards,
<BR>Brian
<PRE>--&nbsp;
------------------------------------------------------------------------ Brian Rasmusson, Software engineer &amp; analyst&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; e-mail: br_at_belle.dk Belle Systems A/S&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; web&nbsp;&nbsp; : www.belle.dk Network, Internet and communication specialists&nbsp;&nbsp;&nbsp;&nbsp; phone : +45 59442500 ------------------------------------------------------------------------</PRE> &nbsp;</HTML> --------------1B38661E552FC8FFD82B6853--
Received on Fri Dec 12 1997 - 00:00:00 CST

Original text of this message

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