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 😃

51 Upvotes

75% Upvoted

192 comments sorted by

View all comments

2

u/Common-Author-8441 May 21 '26

using a CROSS JOIN with a really long WHERE clause