|Subject||Re: [IBO] Is it possible to change plan of a query?|
If u used GBAK to get a ODS11.0 or FB2.0, it recalculates the selectivity
----- Original Message -----
From: "Dany M" <arbit@...>
Sent: Saturday, December 09, 2006 4:46 PM
Subject: Re: [IBO] Is it possible to change plan of a query?
> Marco Menardi wrote:
>> Hi, I've big troubles with FB 2.0 (IBO 4.7beta11) because of the FB2.0
>> choosing a "suicide" plan for certain query I use.
>> A query, for instances, takes 3 seconds under 1.5 while takes 100% CPU
>> for some minutes (well, after a while I've terminated it) with 2.0.
>> Is not an IBO problem, since it happens with other FB management tools
>> as well.
> Did you recalc selectivity after upgrading? /D
> IB Objects - direct, complete, custom connectivity to Firebird or
> without the need for BDE, ODBC or any other layer.
> http://www.ibobjects.com - your IBO community resource for Tech Info
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links