Index Calculation Question

The Oracle7 Server Administration guide (pg 8-37 for OpenVMS) shows an example of calculating the avg. index size for an index of a table. The book states

        Entry Header	2 bytes
        ROWID		6 bytes
        F			Total len bytes of all columns that store 128 bytes or 
            less...
        V			Total len bytes of all columns that store 128 or more ...
        D			Combined data space of all index columns

The book tends to lead one to believe that the size is calculated on all columns of the table. Is it actually only the columns that are used as indexes or is it actually all columns ? (I think it is only the columns usedas indexes). This would tend to make the tablespace size somewhat smaller for theindexes that the tablespace size for the actual tables that will be indexed...

Also, the Entry Header in the book states 2 bytes, but the example below it uses 1 byte..
Is it 1 byte or 2 bytes ????

Can someone please confirm these observations.

Thanks
stan_novinsky_at_jhuapl.edu

• System Configuration: *
• *
• VAXstation 4000/90 * *
• *
• OpenVMS 6.1 *
• Oracle 7.1, Forms 4.0 *
• 3 RZ28's *
• 128 Meg Mem *

  ---