Special occasion Equi Join

I came across this particular script that uses the special equi join form.

SELECT * 
FROM 
per_assignments a, per_assigment_types b
WHERE
a.assignment_status_type_id + 0  = b.assignment_status_type_id

Why is zero added to equi join? I found out that this is due to the fact that you are avoiding index searches, but still someone can explain the full picture of the same. thanks in advance

Edit:

This is not something related to Table / Column declarations. As far as I know, this has to do with SQL tuning.

Here is what I found: -

• This is used in smaller tables.
• Instead of simply searching for the index, it will search the complete table at a time.

But I really don't know exactly what the difference is with normal equi-join, especially since indexing affects performance.

, - , , . : -)

:

NUMBER (9)