index size
Posted in 2000
samir — — source: Informix-list mailing list archive (1991-1998)
Hi all,
I have a table with a unique index on (col1 char(8),
col2 char(15),
col3 char(1))
and a primary key using this index.
I was expected to have a index size equal to 1+15+8+4+1=29, but when a
execute dbschema for this table a get a index size=42.
I have altered the fragment for the index and the table in the
correspendante dbspace, but the index size remane 42 with dbschema.
so please what am i losing here ??
please help !!
I am using inforix 7.30 UC5 under AIX 4.3.2