3 ms·
This article is everything that's wrong with SQL. How about just providing us access to the query plan and allowing users to directly modify it? It's like need
by deltaonefour 5y ago
This article is everything that's wrong with SQL.
How about just providing us access to the query plan and allowing users to directly modify it? It's like needing assembly language to optimize a really tight section of code but having that access blocked off.
Why do we have to rely on leakage to a higher level interface in order to manipulate the lower level details? Just give us manual access when we need it.
- shock-value 5y agoI think SQL is generally great but I do agree with you. Access to lower level primitives from which one could construct their own query plan would be awesome. Query hints (not available in Postgres) would also probably get you a lot of the way there.