Hi everyone,

I have two identical installations of Firebird 1.0.3 running on Win2K
Server boxes. Both clients and servers use one and the same gds32.dll(ver. 6.2.3.972)
which comes with FB 1.0.3.

One of the boxes is in production environment and the other is my test
box. I backup the production database and restore it locally for tests. The
problem is that I receive two different query execution plans on one
and the same query. No data was modified.

On my test box (fortunatelly) I get a full table scan for a table with
150K records so it executes for 13sec while on the production database
an index is used and the same result executes for 90ms!!!

Indexing is one and the same on both databases.

Anyone help?

--
Best regards,
Alexander mailto:saho@...