News for hackers. Stuff that matters.
Re:The SQLite Index Suggester by A321321 on Tuesday July 05, 2022 @02:35PM (#31991986)
Microsoft SQL Server definitely has suggestions for missing indexes. The quality of the suggestions are debatable though
Re:The SQLite Index Suggester by gfody on Tuesday July 05, 2022 @02:44PM (#31992102)
sql server has the index tuning wizard (itwiz) that will sample your data and make suggestions, and more lately the missing index stuff as a consequence of how the execution planner is designed (iirc it tries to generate optimal plans regardless of what indexes are available and when plans are eliminated because the necessary indexes don't exist it emits records for the various "missing index" dmvs)
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.
Re:The SQLite Index Suggester by iasay on Tuesday July 05, 2022 @03:14PM (#31992466)
Indeed. It's even more fun when it starts generating really bad execution plans for table statistics it has completely got wrong, almost always while I'm eating my lunch.
Re:The SQLite Index Suggester by krylon on Tuesday July 05, 2022 @02:39PM (#31992047)
Thank you!