Answers here. http://jonathanlewis.wordpress.com/2009/05/22/index-size/ 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----- Original Message ----- From: <genegurevich@xxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx> Sent: Thursday, July 02, 2009 7:55 PM Subject: create_index_cost procedure
Hello everybody: I am using create_index_cost procedure (oracle 10.2.0.3) to estimate the size of a future index and find an appropriate tablespace parameters for it. Here is my code:
-- //www.freelists.org/webpage/oracle-l