Is a JOIN faster than a WHERE?
baris
Posted on September 13, 2021
Suppose I have two tables that are linked (one has a foreign key to the other):
CREATE TABLE Document (
Id INT PRIMARY KEY
Name VARCHAR 255
)
CREATE TABLE DocumentStats (
Id INT PRIMARY KEY,
DocumentId INT, -- this is a foreign key to table Document
NbViews INT
)
…
💖 💪 🙅 🚩
baris
Posted on September 13, 2021
Join Our Newsletter. No Spam, Only the good stuff.
Sign up to receive the latest update from our blog.