Is SELECT * Expensive?

I explain why and when SELECT * can become expensive.