Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

TRUNC() prevents database from using index. Will last_day also do this?

629600Dec 8 2009 — edited Dec 9 2009
Hi all,

ADDM tells me, that an index is not used because i am using TRUNC on a column where dates are stored in.
I am wondering whether LAST_DAY is better for that?

Regards
Marco
This post has been answered by JustinCave on Dec 8 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 6 2010
Added on Dec 8 2009
2 comments
991 views