JOIN with primary keys
JOIN with indexes
JOIN with triggers
JOIN with stored procedure
JOIN with bulk data