Index Fragmentation

Hi, I have a performance issue with a fragmented tables/indexes. My question is how the attached index, which does'nt contain fragmented key column, gets fragmented? What strategy it uses? What happens internally? for example - CREATE TABLE tb1(a int, b int) FRAGMENT BY EXPRESSION (a >=0 and a < 5) IN dbspace1, (a >=5 and a < 10) IN dbspace2... ; CREATE INDEX idx1 ON tb1(a); CREATE INDEX idx2 ON tb1(b); In the above example, index idx2 also gets fragmented across both dbspaces whereas table is fragmented on column a. What strategy it uses to fragment such indexes? thanks in advance. Prasad Mahale DBA Informix pmahale@yahoo.com ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com