AW: AW: [firebird-support] Optimize query for date ranges

2015-10-13 Thread 'Parzival' parzival1...@gmx.at [firebird-support]
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

Re: AW: [firebird-support] Optimize query for date ranges

2015-10-13 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
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

Re: [firebird-support] Optimize query for date ranges

2015-10-13 Thread setysvar setys...@gmail.com [firebird-support]
>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

AW: [firebird-support] Optimize query for date ranges

2015-10-12 Thread 'Parzival' parzival1...@gmx.at [firebird-support]
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

Re: [firebird-support] Optimize query for date ranges

2015-10-12 Thread Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
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

[firebird-support] Optimize query for date ranges

2015-10-11 Thread 'Parzival' parzival1...@gmx.at [firebird-support]
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 -

Re: [firebird-support] Optimize query for date ranges

2015-10-11 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
> 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

AW: [firebird-support] Optimize query for date ranges

2015-10-11 Thread 'Parzival' parzival1...@gmx.at [firebird-support]
] 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