Post #1768956
2026-03-01 10:29 UTC
How it works is also clever: it analyses the where and order by clauses of the query, creates indexes based on that, retries the query and checks which indexes have been used. Simple but effective!
Replies (1)
-
@AliCatAD@thicc.horse 2026-03-02 08:11
@bohwaz this takes me back 20 years to using EXPLAIN SELECT in MySQL and the like 😺 (although having to then determine and add the indexes based on its output myself)