On: INNER JOIN ON vs WHERE clause (2009)

[notachatbot123]

> Then I ran EXPLAIN for both of them and the query plan is THE same.

*according to a LLM. Did you verify this?

[sgarland → notachatbot123]

My god, this is where we’re at? Asking an LLM to hallucinate a schema and the resultant EXPLAIN plans for given queries?

Postgres is incredibly easy to spin up in a container to test things like this, and the mentioned schema (Postgres Air) is also freely available.

[santiagobasulto → notachatbot123]

Guys, I ran an EXPLAIN in a dockerized postgres server. You can see it in the screenshot I shared. Why did you assume I was just trusting the LLM? Jeez, Hn.

[notachatbot123 → santiagobasulto]

I mean the actual EXPLAINs. Were they actually exactly 100% the same?

[jgalt212 → notachatbot123]

seriously. I'd never ask an LLM a question I had no idea what the answer was.

[0cf8612b2e1e → notachatbot123]

Glad you pointed this out. I was assuming author ran an actual explain. Not that the LLM made a guess.