Row Goals Gone Rogue

  This post discusses “row goals“, but with a twist. The point is to illustrate how row goals can cause unnecessarily slow queries. First, run this script: USE tempdb GO IF OBJECT_ID (‘even’) IS NOT NULL DROP TABLE even; IF OBJECT_ID (‘odd’) IS NOT NULL DROP TABLE odd; GO CREATE TABLE even (c1 int, c2…

1