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.
I don't know if it's still around, but in mid-2000s it was light years ahead of any other database.