Hi,

when I execute this statement in IB_SQL, WinXP Pro, FB SS 1.5.1

SELECT *
FROM MSG
WHERE MSG_ID_MSG IN
(54,93,586,1626,2350,2985,7339,7704,7892,8198,8570,8994,9123,9316,9610,9674,9835)


I get this plan:
PLAN (MSG INDEX
(RDB$PRIMARY58,RDB$PRIMARY58,RDB$PRIMARY58,RDB$PRIMARY58,RDB$PRIMARY58,RDB$PRIMARY58,RDB$PRIMARY58,RDB$PRIMARY58,RDB$PRIMARY58,RDB$PRIMARY58,RDB$PRIMARY58,RDB$PRIMARY58,RDB$PRIMARY58,RDB$PRIMARY58,RDB$PRIMARY58,RDB$PRIMARY58,RDB$PRIMARY58))

The field MSG_ID_MSG is the PK of table MSG.
Just wondering if this kind of plan is normal...

TIA,
markus