• Its also depends on whether the columns you are joining on are indexed.

    Indexing and performance is a large topic in it's own right.

    Too many indexes on a large table may slow down INSERT, UPDATE and DELETE whilst giving improvement to SELECT.

    Where possible, I prefer JOINS from a readability point of view.

    :exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation: