Sandro wrote:
-----------------
...
CREATE INDEX TT_CDP ON TTALAO(TT_SIG, TT_DTP, TT_CCU);
CREATE INDEX TT_CDR ON TTALAO(TT_SIG, TT_DTR, TT_CCU);
CREATE INDEX TT_CHT ON TTALAO(TT_SIG, TT_TAL, TT_CCU);
CREATE UNIQUE INDEX TT_CFR ON TTALAO(TT_SIG, TT_FBR, TT_LOT, TT_PRG,
TT_TAL, TT_CCU);
CREATE UNIQUE INDEX TT_CHA ON TTALAO(TT_SIG, TT_PED, TT_LOT, TT_PRG,
TT_TAL, TT_CCU);
CREATE UNIQUE INDEX TT_CHL ON TTALAO(TT_SIG, TT_LOT, TT_PRG, TT_TAL, TT_CCU);
CREATE UNIQUE INDEX TT_CHP ON TTALAO(TT_SIG, TT_PRG, TT_LOT, TT_TAL, TT_CCU);
CREATE UNIQUE INDEX TT_CPE ON TTALAO(TT_SIG, TT_LOT, TT_PED, TT_PRG,
TT_TAL, TT_CCU);
CREATE UNIQUE INDEX TT_CPF ON TTALAO(TT_SIG, TT_FBP, TT_LOT, TT_PRG,
TT_TAL, TT_CCU);
CREATE UNIQUE INDEX TT_CPL ON TTALAO(TT_SIG, TT_DTP, TT_LOT, TT_PRG,
TT_TAL, TT_CCU);
CREATE UNIQUE INDEX TT_CPR ON TTALAO(TT_SIG, TT_PRO, TT_LOT, TT_PRG,
TT_TAL, TT_CCU);
CREATE UNIQUE INDEX TT_CRL ON TTALAO(TT_SIG, TT_DTR, TT_LOT, TT_PRG,
TT_TAL, TT_CCU);
CREATE UNIQUE DESCENDING INDEX TT_CHA_DESC ON TTALAO(TT_SIG, TT_PED,
TT_LOT, TT_PRG, TT_TAL, TT_CCU);
...
--------------------

What is the PLANs used?
You have all indexes starting with the same field (TT_SIG) - this used to
confuse the IB optimizer, maybe this still holds true for Fb 1.0.2.908?

--
Aage J.