I have seen many times that a few developers like to write SELECT * instead of column names. It’s definitely a bad habit and not the coding standard of-course. Few times I was reverted back saying that the table/view have very few columns and does not really matter if you write the *. Yes it saves the time during development but it kills the performance on production. If you know a few tricks then it is just a click away. I will explain two shortcuts here, choose the one that is most convenient for you but please stop writing SELECT *.
Note: One time setup is required, please follow the screen captures.