Subject | Re: [ib-support] Same Query - Dirrerent GDBs - Different Plan |
---|---|
Author | Ivan Prenosil |
Post date | 2002-10-02T16:01:34Z |
> I run the same query on two different GDBs with EXACTLY the sameHave you tried updating index statistics ?
> 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.
Ivan
http://www.volny.cz/iprenosil/interbase