Subject Re: [ib-support] Same Query - Dirrerent GDBs - Different Plan
Author Ivan Prenosil
> I run the same query on two different GDBs with EXACTLY the same
> metadata. The user data is different. I run a query and on one GDB is
> instant to execute - the other it takes about 30 seconds ( same local
> server - my pc ). I noticed a different plan was being used.

Have you tried updating index statistics ?

Ivan
http://www.volny.cz/iprenosil/interbase