TO_DATE and indexes
we have a table where the column is of type VARCHAR2 but is populated with dates. So we use To_date in the select query but it does not pick up the indexes.
Is there a solution for this problem for db ver 8.0.5 or 8.1.7?
i) Use to_char in the select query
ii) Redefine the table and application.
don't store dates in varchar2 fields.
Change the datatype to date.
Remember the Golden Rule - He who has the gold makes the rules!
Ph.D., OCP 8i, 9i, 10g DBA
Thanks for your reply guys.
any ideas about the most efficient way to change the column datatype of a high-availability table which has around a million rows in 8i?
Another possible solution is using Function Based Index.
But this is buggy and I personally hate it.
Click Here to Expand Forum to Full Width