Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Estimating index sizes
--------------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: 7bitReceived on Fri Dec 12 1997 - 00:00:00 CST
<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>--
------------------------------------------------------------------------ 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 ------------------------------------------------------------------------</PRE> </HTML> --------------1B38661E552FC8FFD82B6853--