Hello Jason,

Is this caused by IB6 or IBO4 ?

Table with key fields a,b,c

Case 1: 2 indexes (a,b) and (c)

Case 2: 1 index (a,b,c)

Select * from Table where a = :a and b = :b and c = :c

is a couple of magnitudes slower in Case 1 than Case 2

It sure pays off to closely examine the PLAN(s) shown by IB_WISQL
even on fragments of stored procedures :)

Best Regards
Hans