tag:blogger.com,1999:blog-25740336.post114484062921683607..comments2023-08-24T22:26:48.675+01:00Comments on The PeopleSoft DBA Blog: %CurrentDateIn MetaSQL prevents Oracle CBO from correctly evaluating selectivity of predicate (up to Oracle 9i)David Kurtzhttp://www.blogger.com/profile/00468908370233805717noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-25740336.post-45556743135125537162008-01-15T21:05:00.000+00:002008-01-15T21:05:00.000+00:00The problem with %CurrentDateIn described in this ...The problem with <I>%CurrentDateIn</I> described in this posting applies to Oracle 9<I>i</I>, but is no longer a problem in 10<I>g</I>. There has been a change to the way Oracle costs predicates containing expressions (see <A HREF="http://blog.psftdba.com/2007/12/changes-in-calculation-of-predicate.html" REL="nofollow">http://blog.psftdba.com/2007/12/changes-in-calculation-of-predicate.html</A>).David Kurtzhttps://www.blogger.com/profile/00924323960047469300noreply@blogger.com