Creating one of the two index I wrote aboive and one new index with str_id and both date_id and date_id + interval solved the issue, the DBMS understood what I wanted to do and actually started using the new indexes.