At this point it's malpractice not to use AI to analyze your SQL statements and tables for optimizations

Are we on bizarro HN?

No, you ask the DB to EXPLAIN itself to you.

	▲	Arch-TK 15 hours ago \| parent [-]
		Next you'll be telling me that instead of asking AI to find my bug I should just use print statements or a debugger to observe the state of my program over time to find where it deviates from expectations and figure it out that way.

▲

mjb 5 hours ago | parent | prev [-]

I agree. Modern code models tend to do a great job advising in SQL, especially if you include the table definition and EXPLAIN output in the context. Alternatively, I've found that an EXPLAIN MCP tool works well.