Index key compression in informix?

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.

The index format is usually Key, Rowid, Del flag ...we add the fragment information too if its detached index on a fragmented table ... so if there are duplicate keys, its not the key which is repeated but the ROWID ..:-) So, say, if the key is of datatype char(10) and the key is say "Test" then within the index it will have the key as "Testbbbbbb" (where b is a blank space) HTH Thanx much, Rajib Sarkar Advisory Support Engineer (Wells Fargo Bank) IBM Data Management Group Ph : (602)-217-2100 Fax: (602)-217-2100 As long as you derive inner help and comfort from anything, keep it -- Mahatma Gandhi "Bob Amy " <bamy@ssww.com> To: ids@iiug.org Sent by: cc: forum.subscriber@ Subject: Index key compression in informix? [341] iiug.org 02/12/2003 08:00 AM 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.