3 ms·
simplicity, for one - write a quick query to retrieve all recipes that contain all of any number of ingredients. SELECT * FROM recipes r INNER JOIN ingred
by jerrysievert 9y ago
simplicity, for one - write a quick query to retrieve all recipes that contain all of any number of ingredients.
SELECT * FROM recipes r
INNER JOIN ingredients i ON (r.id = i.recipe_id)
WHERE i.ingredient IN ('mushrooms', 'sour cream')
load up some data and run explain analyze on both schemas/queries.