Try in 2.0 to backup & restore the database, after try to drop all indexes
and create again, test the query ( but do not force the old plan ).
If you have the same result, send me both databases to test, because I am
very curios about this problem ( if are big only with the required tables).

On 2/28/07, Félix González <felix.gonzalez@...> wrote:
>
> It´s the same database backup with 1.5 and restore with 2.0. in 2.0 I´ve
> forceed to use the same plan
>
> thanks
>
> _____
>
> De: firebird-support@yahoogroups.com <firebird-support%40yahoogroups.com>
> [mailto:firebird-support@yahoogroups.com<firebird-support%40yahoogroups.com>]
> En nombre de Svein Erling Tysvaer
> Enviado el: miércoles, 28 de febrero de 2007 15:58
> Para: Firebird-support
> Asunto: Re: [firebird-support] Firebird 2.0 vs 1.5
>
> In your case, +0 tells the optimizer that it cannot use an index for
> Fecha. If Fb2.0 uses the same plan as Fb 1.5 and still is slower, then I
> am very surprised and have no idea what to suggest... Are you sure that
> the only difference between the two are the speed - i.e. same plan, same
> data, same result set and similar database statistics (no large gap
> between transactions)?
>
> Set
>
> Félix González wrote:
> > The plans were diferent, I=B4ve sentence on FB2.o in order to use the
> same
> > plam that FB1.5 use, but the result are similar FB2.0 are slower.
> >
> > What=B4s means +0?
> >
> > De: firebird-support@ <mailto:firebird-support%40yahoogroups.com>
> yahoogroups.com
> > [mailto:firebird-support@ <mailto:firebird-support%40yahoogroups.com>
> yahoogroups.com] En nombre de Svein Erling Tysvaer
> > Enviado el: martes, 27 de febrero de 2007 20:52
> > Para: firebird-support@ <mailto:firebird-support%40yahoogroups.com>
> yahoogroups.com
> > Asunto: Re: [firebird-support] Firebird 2.0 vs 1.5
> >
> > =20
> >
> > I think you ought to compare the plans between Fb 1.5 and Fb 2.0=20
> > (without them, any comment is just guessing), though if you are right=20
> > that it is the fecha field that is the problem, then the solution may
> be=20
> > to add +0 like this:
> >
> > Select sum(debe)
> > From apuntes
> > Where CodEjericio =3D :codEjercicio
> > And Fecha+0 between :fecha1 and :fecha2
> > And cuenta =3D :Cuenta
> >
> > HTH,
> > Set
>
> [Non-text portions of this message have been removed]
>
>
>



--
-- \nBest regards,\n Dragos Hilbert mailto:
dragos.hilbert@...\n
-------


[Non-text portions of this message have been removed]