At 08:43 PM 9/20/2001 +0200, Tobias Giesen wrote:

>The worst non-optimized thing is just one location in the application where
>it needs to read in the complete primary key column of a table that's up to
>10k rows big. Do you know if such a query is satisfied from the PK index?

Yes. InterBase and Firebird never return data directly from the index
because the indexes may contain data that is not part of the scope of the
current transaction. The only way to be sure is to read the record.


Regards,

Ann
www.ibphoenix.com
We have answers.