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@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] En nombre de Svein Erling Tysvaer
> Enviado el: martes, 27 de febrero de 2007 20:52
> Para: firebird-support@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