I have an index in Oracle of type ‘date’ (with no timestamp).
When filtering on this field in the explore, I am unable to avoid a TO_TIMESTAMP() cast being added by Looker.
This results in an index scan rather than an index seek.
I have tried various solutions such as changing the dimension LookML with no luck.
Any ideas on how Looker can use an index in Oracle of type ‘date’?