News for hackers. Stuff that matters.
Re:SQLite's Automatic Indexes by hinkley on Wednesday December 28, 2022 @02:43PM (#34164987)
If EXPLAIN is little known then we have failed as educators, mentors and peers.

It does amaze me the gaps that people have, though.

Re:SQLite's Automatic Indexes by haggy102 on Wednesday December 28, 2022 @07:17PM (#34167848)
I'm glad you said it because I was about to say the exact same thing.
Re:SQLite's Automatic Indexes by krylon on Thursday December 29, 2022 @08:16AM (#34172287)
My gut feeling is that it's fairly well known, but few people use it. Including yours truly.

Then again, I have rarely run into performance issues with database engines. Either the ones I've had contact with (SQLite, MSSQL, Postgres) are very good at what they do (which I suspect they are), or my requirements were too puny for them to break a sweat (which I also suspect to be the case).

I did use MSSQL Studio's query analyzer once to fix a performance issue and was able to get the query in question from nearly an hour down to under a second. triumphant grin I don't remember the details of the query, but the solution was to use a hash join.