postgresql

1. Avoid join if possible use subquery instead of join Note : subqueries can be slower than LEFT [OUTER] JOINS, but in my opinion their strength is slightly higher readability. Some Other Example : 2.If you need to join the …