We have created a reflection on one of our tables. No joins, no nothing, just a pure aggregate reflection on certain columns.
If I query the table without datetime parameters (“ido” in our case) the reflection is used and the query is accelerated. However, if I include the “ido” datetime WHERE clause, the query is not accelerated.
Granularity is set to “day”, and as you can see from the profiles, the “ido” datetime column is part of the aggregation.
Same thing happened, with a different set of data… I am sure I am missing something but some help would be appreciated.
I attached both profiles for the properly accelerated and the unaccelerated query with datetime filter.