Oracle Index Sizing Question
From: Gerry Lurette <gerard_at_magi.com>
Date: 1996/03/27
Message-ID: <315A2F8B.7628_at_magi.com>#1/1
Date: 1996/03/27
Message-ID: <315A2F8B.7628_at_magi.com>#1/1
This is based on an 'Analyze Table(or Index) Compute Statistics' script already having been run.
Is there a more simplified way of sizing Oracle indexes to get a general estimate than following the 'Calculating Space for Indexes' in the Oracle7 Server Administrators Guide?
In sizing tables, I multiply num_rows*avg_row_len from user_tables to get a general estimate.
Any answer appreciated!
-- __&__ / \ | | ^^ (o)(o) C ,---_) | |,___| "I am Homer of Borg. You will be assimilated. Resistance | \__/ is futile. Preparation is irrel...MMMmmm...doughnut!" /_____\ /_____/ \ Gerry Lurette (gerard_at_magi.com)Received on Wed Mar 27 1996 - 00:00:00 CET