tag:blogger.com,1999:blog-5794742462833718439.post7183216368294158727..comments2024-03-26T16:41:52.813+06:00Comments on ORACLE: DBA's day out: The Clustering Factor Of IndexMohammad Hasan Shaharearhttp://www.blogger.com/profile/16334901749628047963noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-5794742462833718439.post-87429626661623100132008-10-07T15:34:00.000+06:002008-10-07T15:34:00.000+06:00Estimate the physical size of an index without cre...Estimate the physical size of an index without creating it...<BR/><BR/>--set serveroutput on;<BR/><BR/>DECLARE<BR/> ub NUMBER;<BR/> ab NUMBER;<BR/>BEGIN<BR/> dbms_space.create_index_cost('CREATE INDEX u_a_i_space ON user_activity(datestamp) LOCAL', ub, ab);<BR/><BR/> dbms_output.put_line('Used Bytes: ' || TO_CHAR(ub));<BR/> dbms_output.put_line('Alloc Bytes: ' || TO_CHAR(ab));<BR/>END;<BR/>/Shuvo's Bloghttps://www.blogger.com/profile/17283265002010454419noreply@blogger.com