Re:Imperative Thinking and the Making of Sandwiches (2014)
by ksherlock on Monday August 16, 2021 @07:02AM
(#28196773)
Most SQL engines have an EXPLAIN / EXPLAIN PLAN statement.
[ Parent
| on HN ]
Re:Imperative Thinking and the Making of Sandwiches (2014)
by TeMPOraL on Monday August 16, 2021 @10:11AM
(#28198314)
Yup. For me, this is very much anxiety-removing.
And this was, in a way, the point of the article. It was explicitly mentioned that the desired thing isn't some wide abstraction hiding everything, backed by a Sufficiently Smart Compiler that makes it Do What I Mean. No, the desired state is good enough abstractions plus interactive usage.
In SQL case: you write your query, run EXPLAIN on it, notice it'll run slow because $reasons, add an index, rerun EXPLAIN, ...