Subject plan
Author Markus Ostenried
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):


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 on WinXP Pro with IB_SQL (IBObjects 4.2 He).