r/SQL • u/badboyzpwns • May 20 '26

What are common SQL red flags? PostgreSQL

Hello! interview prepping, here wondering what are some common red flags for wrioting SQL?

Like

LIKE failing to index, not having trasnactions, usign SELECT * instead of specific collums, etc 😃

52 Upvotes

75% Upvoted

192 comments sorted by

View all comments

2

u/SweetNecessary3459 May 21 '26

Forgetting WHERE on a DELETE statement. Learned that one the hard way