Hi all,

for this simple query (the column ID_Client is defined as Integer not null
primary key)

select * from clienten
where id_client in (3768,3771,3769,3770,3772,5116);

I get this plan (using IB_SQL):

PLAN (CLIENTEN INDEX
(RDB$PRIMARY5,RDB$PRIMARY5,RDB$PRIMARY5,RDB$PRIMARY5,RDB$PRIMARY5,RDB$PRIMARY5))

For every additional value in the "IN value list" I get another
"RDB$PRIMARY5" added to the plan.
Is this normal behavior ? Could I specify a faster plan with just one
"RDB$PRIMARY5" ? I tried this but IB_SQL still shows the above plan.

I'm using Firebird 1.0.2.908 on WinXP Pro with IB_SQL (IBObjects 4.2 He).

Thanks,
Markus