[firebird-support] Optimize query for date ranges

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

> 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

Hello, there are two indices on the field DATUM: One ascending, the other one descending. Plan: PLAN (A INDEX (IDX_ARBEITSEINTEILUNG1)) Adapted plan: PLAN (A INDEX (IDX_ARBEITSEINTEILUNG1)) Niko Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]