Subject Re: [IBO] Is it possible to change plan of a query?
Author Dany M
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