News for hackers. Stuff that matters.
Re:The SQLite Index Suggester by dmitriid on Tuesday July 05, 2022 @04:44PM (#31993460)
Microsoft SQL Server query analyzer was was essential in identifying missing indexes. Wherever you saw "full table scan" on a table, you knew it was missing an index.

I don't know if it's still around, but in mid-2000s it was light years ahead of any other database.

Re:The SQLite Index Suggester by striking on Tuesday July 05, 2022 @06:55PM (#31994748)
https://explain.dalibo.com/ and https://explain.depesz.com/ are indispensable tools for visualizing Postgres' EXPLAIN output in a similar way. I will agree that the MSSQL query visualizer is more visually effective, though.