Is a JOIN faster than a WHERE?

boyukbas

baris

Posted on September 13, 2021

Is a JOIN faster than a WHERE?

Is a JOIN faster than a WHERE?

65

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
)

💖 💪 🙅 🚩
boyukbas
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.

Related