4 ms·
"Maybe one day I’ll learn to read a query plan." Query plans aren't that hard to read! [0] 0 - https://xkcd.com/2501/ https://xkcd.com/2501/
by datadrivenangel 3mo ago
"Maybe one day I’ll learn to read a query plan."
Query plans aren't that hard to read! [0]
0 - https://xkcd.com/2501/ https://xkcd.com/2501/
- inigyou 3mo agoThey might mean the output from EXPLAIN which is definitely hard to read in sqlite as it shows you the transaction bytecode.
- bambax 3mo agoThey're harder to completely understand than they are to read; it often happens for example that SQLite won't use existing indexes, for no obvious reason.
- deathanatos 3mo agoThey're not hard to read until you see the queries that coworkers at large companies tend to generate. If the query is a novella that joins half of humankind's know data sources, the query plan tends to not be much better. Then there's always the dreaded question: "why is it slow?" "Because you're making the database yearn for the sweet release of death."