IF EXISTS should select 1 not *
Opened this issue · 0 comments
Wes-Reid commented
The conditional statement should generate SELECT 1 FROM not SELECT * FROM. The check is the same but is more efficient. We don't need to bring back all the data for the row.