Databases · Junior · Question 20 of 75

Why is `SELECT *` often avoided in application code?

1It returns rows in random order
✓Correct answer: It fetches columns you don't need, breaks when columns change and can prevent index-only scans
3It is not valid SQL

Explanation

Listing columns makes queries explicit and cheaper to transfer, especially when tables have large text or JSON columns.

Further reading

Test yourself

Take the Databases · Junior quiz: questions and options are shuffled, and you get a review of your mistakes at the end.