Reset the statistics on every table. That's what bit me, I had
recreated the database tables and primary keys with DDL scripts, and
then pumped the data over. Because of that the calculated selectivity
of the primary keys were all zero, and none of them were ever used in
queries.

Rick DeBay

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Hans
Sent: Sunday, December 03, 2006 7:07 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] FB 2.0 / FB1.5 optimizer difference

Hello,

I carefully converted a long time running a FB1.5 application to FB2.0,
took care of the differences of the 'not in' instances. But I experience
just a few queries execute faster, but most execute are 2 to 40 times
slower. Most even showing the same plans as FB1.5. Database
characteristics the same. Database only about 500M in size.
What else can I present, do or to assist ?

Best Regards
Hans



++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item on the
main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links




Disclaimer: This message (including attachments) is confidential and may be privileged. If you have received it by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. RxStrategies, Inc. shall not be liable for the improper or incomplete transmission of the information contained in this communication or for any delay in its receipt or damage to your system. RxStrategies, Inc. does not guarantee that the integrity of this communication has been maintained nor that this communication is free from viruses, interceptions or interference.