SORT_SEQUENCE is wrong in as400 library indexes. Can this cause performance issues?
Solution: Sort Sequence

In short the problm occured from incorrect client odbc setup, making the indexes not *HEX but langauage specific , rendering the index ussage useless fromn server point of view.