The result cache is not being used on the following query: select * from ORDERS Where O_ORDERDATE = date_trunc('day', current_timestamp()); The query is run hun...