What exactly is the benefit when +0 is added?

SQL Optimizer SQL Optimizer for Oracle
1

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

2

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.

Regards,
Greg

See this post for an equivalent explanation for character columns:
http://sqloptimizeroracle.inside.quest.com/thread.jspa?threadID=35542&tstart=0