unnecessary I/O
increase network traffic
more application memory
depends on column order
fragile views
conflict in join query
risky while copying data

脆弱的视图
新增列破坏既有视图

7 Reasons Why Using SELECT * FROM TABLE in SQL Query Is a Bad Idea
https://dzone.com/articles/why-you-should-not-use-select-in-sql-query-1