2.1 Tuning for SELECT * and Lots of Rows

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 a few sets of advanced tuning tricks…