Hi Friends,

I am always confused about selecting columns with date datatypes and the performance associated to it
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 because i am
reformatting the column with a function right?

How can I write the query to use the index performance?


Thanks hunnie