>>It looks like this was supposed to be fixed in SP1, "Indexes on STR() are penalized during >Not tested, but what about this index expression as a workaround:

>INDEX ON PADL(TRANSFORM(CUST_NUM),8)+SYS(11,TRANS_DATE)  TAG custhist

Unfortunately, we've got a ton of legacy code that makes changing this index very difficult (and I'm sure we'll run into this in other places).