[firebird-support] Optimize query for date ranges

['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 - 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?

 

Thanks

 

Niko