Is SELECT harmful in Database

Question

Hi!!

Can someone tell me why SELECT* is considered a bad practice? Would it not mean less amount of code to change if you have added a new column?

I know that the SELECT COUNT(*) causes performance issues on some Databases, but what if it's needed on every column?

Answer 1

There are really three major reasons:

• Inefficiency in moving data to the consumer

• Indexing issues

• Binding Problems 

But let me tell you that it's not all bad for SELECT *. You can use for the following use-cases:

• Ad-hoc queries

• When * means "a row"