Hi Friends,
I am always confused about selecting columns with date datatypes and the performance associated to it:rolleyes:
Example:
sql> select hiredate from EMP where hiredate='01-JAN-06';
no rows selected.
sql> select hiredate from EMP where trunc(hiredate)='01-JAN-06';
hiredate
--------
01-JAN-06
If I have indexed on hiredate and the EMP contains million rows...
then it will be doing full table scan :confused: because i am
reformatting the column with a function right?
How can I write the query to use the index performance?
Thanks hunnie