I agree that it isn't sufficient to Select *
, if that one you don't need, as mentioned elsewhere, is a BLOB, you don't want to have that overhead creep in.
I would create a view with the required data, then you can Select *
in comfort --if the database software supports them. Else, put the huge data in another table.