atabase Health Check, Tuning etc.
> Niko
>
> -Ursprüngliche Nachricht-
> Von: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com]
> Gesendet: Montag, 12. Oktober 2015 17:31
> An: firebird-support@yahoogroups.com
> Betreff: Re: [firebird-support] Optimize
On Tue, Oct 13, 2015 at 3:47 PM, 'Parzival' parzival1...@gmx.at
[firebird-support] wrote:
> Hello Thomas,
>
> the result set contains 3 record for criteria.
>
> Records DATUM >= '5.10.2015' = 102
> Records DATUM <= '11.10.2015' = 26
>
> It seems that both
>SELECT * FROM ARBEITSEINTEILUNG AS a where a.baustelle = '12345' AND
>a.DATUM >= '05.10.2015' AND a.DATUM <= '11.10.2015';
>
>PLAN (A INDEX (IDX_ARBEITSEINTEILUNG1))
>
>there are two indices on the field DATUM: One ascending, the other one
>descending.
>
>Records DATUM >= '5.10.2015' = 102
r 2015 17:31
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] Optimize query for date ranges
Niko,
> Hello all,
>
> i am running a simple query where the result contains 3 records. The
> query should provide all records in a specific week.
>
> SELECT
Niko,
> Hello all,
>
> i am running a simple query where the result contains 3 records. The
> query should provide all records in a specific week.
>
> SELECT * FROM ARBEITSEINTEILUNG AS a where a.baustelle = '12345' AND
> WOCHE = '2015-41';
>
> Some times I dont have a week but two dates:
>
> In
Hello all,
i am running a simple query where the result contains 3 records. The query
should provide all records in a specific week.
SELECT * FROM ARBEITSEINTEILUNG AS a where a.baustelle = '12345' AND WOCHE =
'2015-41';
Some times I dont have a week but two dates:
In this case -
> On Oct 11, 2015, at 5:00 AM, 'Parzival' parzival1...@gmx.at
> [firebird-support] wrote:
> i am running a simple query where the result contains 3 records. The query
> should provide all records in a specific week.
>
>
>
>
> SELECT * FROM
]
Gesendet: Sonntag, 11. Oktober 2015 18:52
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] Optimize query for date ranges
On Oct 11, 2015, at 5:00 AM, 'Parzival' parzival1...@gmx.at
<mailto:parzival1...@gmx.at> [firebird-support]
<firebird-support@yahoog