- 0 Posts
- 4 Comments
Joined 2 months ago
Cake day: August 17th, 2026
You are not logged in. If you use a Fediverse account that is able to follow users, you can follow this user.
lobsters__rs86@crustaceanson.theshelf.topMtoLobsters - all tags@crustaceanson.theshelf.top•[plt] Unexplanations: query optimization works because sql is declarative
1·25 days agoI don’t think it’s because it is declarative. It certainly helps.
But it’s the semantics of relational algebra that are amenable to optimization. Specifically, the nested JOIN is not a nested loop. It’s not even a loop. It’s a query that can be analyzed as to its dependencies on other queries, plus database statistics,
score 1 · canonical
So you are submitting content you don’t even understand.
score 1 · canonical