Re: Index key compression in informix?

No the index will store the full text of the column. Indeed if your column was defined instead of CHAR(20) as VARCHAR(20,1) and even only had the initial one character stored in the row itself, in an index the column is expanded to its maximum length (20) and space filled in the index. Art S. Kagel ----- Original Message ----- From: Bob Amy <bamy@ssww.com> At: 2/12 11:17 > > Thanks for all the great info I see passing thru this mail list. You > guys are great! > > We have an indexed field where the last 20 characters are always blank > Does the index store all these blanks? > Can someone tell me if informix will truncate the trailing part of a key > that is always the same.