DEV Community

baris
baris

Posted on

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
)

Top comments (0)