2.1 Tuning for SELECT * and Lots of Rows (46m)

Sure, you can TELL people not to select all the columns or all the rows, but it doesn’t always work. Sometimes they can’t change the code, sometimes they really do need all the fields, and sometimes you’re just not sure whether it’s even a problem. We lay out two sets of advanced tuning tricks here:…

To access this incredible, amazing content, you gotta get Live Class Season Pass or Mastering Query Tuning, or log in if you already shelled out the cash.