| Subject | Re: [firebird-support] Optimize query for date ranges |
|---|---|
| Author | Ann Harrison |
| Post date | 2015-10-11T16:51:53Z |
On Oct 11, 2015, at 5:00 AM, 'Parzival' parzival1969@... [firebird-support] <firebird-support@yahoogroups.com> 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 ARBEITSEINTEILUNG AS a where a.baustelle = '12345' AND WOCHE = '2015-41';
Some times I dont have a week but two dates:
In this case – the very same number of records = 3 is the result set I see that the table Arbeitseinteilung gots 42 reads.
SELECT * FROM ARBEITSEINTEILUNG AS a where a.baustelle = '12345' AND a.DATUM >= '05.10.2015' AND a.DATUM <= '11.10.2015';
How can I improve the query?
Do you have an index on DATUM? What ate the plans for the two queries?
Good luck,
Ann