• 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?