SELECT *

Difficulty: Beginner

Question

Why is 'SELECT *' usually considered bad practice?

Answer

It fetches more data than needed, increases network traffic, prevents the use of covering indexes, and can break your app if new columns are added to the table.

Concepts covered

Performance, I/O