4 ms·
Microsoft SQL Server definitely has suggestions for missing indexes. The quality of the suggestions are debatable though
by A321321 4y ago
Microsoft SQL Server definitely has suggestions for missing indexes. The quality of the suggestions are debatable though
- krylon 4y agoThank you!
- gfody 4y agosql 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)
- iasay 4y agoIndeed. 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.
- dmitriid 4y agoMicrosoft 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.
- striking 4y agohttps://explain.dalibo.com/ https://explain.dalibo.com/ and https://explain.depesz.com/ 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.