2 edited body
source | link

Which join is better performing if all of them provides the same result?

I addition of the previewsprevious answer, for what I know, MySQL is optimized to have the same performance.

With good indexes, for example, JOIN vs LEFT JOIN + WHERE clause to filter, will be the same thing. Optimization vs Human Reading take sense on large queries with lot of joins.

Using good indexes and cache is more important.

You can read a good explanation of the optimization process here :

The Query Optimization Process : A query can often be executed many different ways and produce the same result. The optimizer’s job is to find the best option.

Which join is better performing if all of them provides the same result?

I addition of the previews answer, for what I know, MySQL is optimized to have the same performance.

With good indexes, for example, JOIN vs LEFT JOIN + WHERE clause to filter, will be the same thing. Optimization vs Human Reading take sense on large queries with lot of joins.

Using good indexes and cache is more important.

You can read a good explanation of the optimization process here :

The Query Optimization Process : A query can often be executed many different ways and produce the same result. The optimizer’s job is to find the best option.

Which join is better performing if all of them provides the same result?

I addition of the previous answer, for what I know, MySQL is optimized to have the same performance.

With good indexes, for example, JOIN vs LEFT JOIN + WHERE clause to filter, will be the same thing. Optimization vs Human Reading take sense on large queries with lot of joins.

Using good indexes and cache is more important.

You can read a good explanation of the optimization process here :

The Query Optimization Process : A query can often be executed many different ways and produce the same result. The optimizer’s job is to find the best option.

1
source | link

Which join is better performing if all of them provides the same result?

I addition of the previews answer, for what I know, MySQL is optimized to have the same performance.

With good indexes, for example, JOIN vs LEFT JOIN + WHERE clause to filter, will be the same thing. Optimization vs Human Reading take sense on large queries with lot of joins.

Using good indexes and cache is more important.

You can read a good explanation of the optimization process here :

The Query Optimization Process : A query can often be executed many different ways and produce the same result. The optimizer’s job is to find the best option.