I am wondering the more I think of it,that perhaps this is what he was trying to move me towards, Lets say:
Select *
From dbo.customers
Would that plan be cached? and be reusable? I am not sure it would be, where as if you selected all the columns. with a
Select c.fname,c.lname,c.contactnumber
From dbo.customers c
Would be cached, that sound right to you guys?