Oracle SQL query is not using index
I’m running the below query in my Oracle DB. The index trunc(create_date) is created on the table ORDERS. But the below query is not using the index when I run it.
I’m running the below query in my Oracle DB. The index trunc(create_date) is created on the table ORDERS. But the below query is not using the index when I run it.