to_char and performance
Dear all,
How does the function to_char have an effect on performance. I have grabed sql statements in the statspack report and found that in most of the statements where date is involved, to_char function is used. Otherwise I did not find any missing indexes but some of the indexes were not used. ( found out about this by monitoring the indexes).
So, I created some functional index on to_char. There was a little gain but not much of a difference.
Please suggest.
Regards
SL