Which is faster/best? SELECT * or SELECT column1, colum2, column3, etc

By optimize you mean you don’t need all columns ?
If you don’t, then request only those that you need.