Re: estimate index size on 9i

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 17 Jan 2007 21:09:35 -0000
Message-ID: <p-WdnXAOmtO3DTPYnZ2dnUVZ8saonZ2d@bt.com>

"oracle dba" <aoracledba_at_gmail.com> wrote in message news:1168929159.960451.140580_at_q2g2000cwa.googlegroups.com...
> hi all,
>
> in oracle 10g we can use dbms_space package to find estimate index size
> before create that one. How it is possible in oracle 9i.
>

Try looking at

http://www.jlcomp.demon.co.uk/index_efficiency_2.html

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Received on Wed Jan 17 2007 - 15:09:35 CST