Toad World® Forums

What exactly is the benefit when +0 is added?

What is the benefit of adding a + 0 to a join?
spriden.spriden_pidm = sfbetrm.sfbetrm_pidm + 0

Hi Calvin,

For a numeric column (sfbetrm.sfbetrm_pidm), appending a “+ 0” has the potential effect of disabling any index on that column which in turn may cause the Oracle optimizer to sometimes choose a different execution plan which is sometimes better performing than the original.


See this post for an equivalent explanation for character columns: