which one run faster in mysql

which开发者_运维知识库 one run faster in mysql: a query with multiple joins or that query with using nested select?

it's impossible to answer in this case. you should analyze each of them with EXPLAIN

Given the correct Indexes on the tables, I would go with saying JOINS would be more performant, but it is always best practice to test the various queries for performance.

In the majority of cases, JOINS are more efficient. This assumes you're joining on columns which are indexed. HOwever, the above answers are right. You need to evaluate your particular query with EXPLAIN to see.