Kehadiran dan ketidakhadiran

Meningkatkan Kinerja Kueri di SQL Server

Dean Smith

Founder, Atamai Analytics

Diagram Venn - kehadiran

Data ada di kedua tabel.

Diagram Venn Kehadiran

Data ada di tabel kiri namun tidak ada di tabel kanan.

Diagram Venn Ketidakhadiran

Database Customers Orders

SELECT CustomerID
FROM Customers






SELECT CustomerID
FROM Orders;

SELECT CustomerID
FROM Customers


INTERSECT


SELECT CustomerID
FROM Orders;

SELECT CustomerID
FROM Customers






SELECT CustomerID
FROM Orders;

SELECT CustomerID
FROM Customers


EXCEPT


SELECT CustomerID
FROM Orders;

CustomerID
FISSA
PARIS

Kelebihan

Kekurangan

Meningkatkan Kinerja Kueri di SQL Server