Re: index size

That's bug 114193. The index size reported by dbschema is wrong. There is currently no plan to fix this bug so you shouldn't rely on dbschema for your index size. Regards, Cristian. samir wrote: > > 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