I used a FB1.5 gbak to backup and FB2.0 gbak to restore to ODS11.0
But I read later that FB2.0 gbak can backup ODS10.1 and ODS11.0, but alwaysy
restores to ODS11.0.
I think that will rebuild the statistics and rebalance the indexes from
scratch ?

Best Regards
Hans

----- Original Message -----
From: "Rick Debay" <rdebay@...>
To: <firebird-support@yahoogroups.com>
Sent: Monday, December 04, 2006 2:12 PM
Subject: RE: [firebird-support] FB 2.0 / FB1.5 optimizer difference


> 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.
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
>
>
>