Index Size
Posted in 1992
Hi netter,
Does anyone know exactly how to calculate the total index size of a
particular table like you see when you do dbschema. According to the
Informix Training 'Book', add 8 bytes to the length of each key, and then
sum up all index entries, this should be the total index size. But this
never work unfortunately.
ex:
{ TABLE "dnguyen".foo_tbl row size = 34 number of columns = 8 index size = 70 }
create table "dnguyen".foo_tbl
(
f1 serial not null,
f2 char(8) not null,
f3 char(1),
f4 char(6),
f5 char(1),
f6 char(1),
f7 char(1),
f8 char(12)
)
create index "dnguyen".i_f1 on "dnguyen".foo_tbl (f8);
create index "dnguyen".i_f23 on "dnguyen".foo_tbl (f2,f3);
create index "dnguyen".i_f1 on "dnguyen".foo_tbl (f1);
create index "dnguyen".i_f4 on "dnguyen".foo_tbl (f4);
thanx in advance...
------------------------------------------------------------------------------
CSC - Partner
Dzi Nguyen
dinguyen@wam.umd.edu
------------------------------------------------------------------------------
--
**********************************************************