1) Join vs Subquery — actual meaning

JOIN

• Tables ko horizontally combine karta (columns add hoti hain).
• Jab tumhe dono tables ka data ek saath chahiye.

Example:

SELECT o.order_id, c.name
FROM orders o
JOIN customer cON c.id= o.cust_id;

Subquery

• Ek query ka result dusri query me input ban jata.
• Often filtering / existence / comparison ke liye.

Example:

SELECT*
FROM customer
WHERE idIN (SELECT cust_idFROM orders);

2) “Joins faster, subqueries slower” — ✅/❌ truth

Reality:

Not always.

Modern DB optimizers (MySQL/Postgres/SQL Server/Oracle) many times:

• subquery ko internally join me convert kar dete hain
• ya join ko subquery-like plan me execute kar dete hain

Performance depends on:

• indexes (FK/PK indexing)