4 ms·
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
by dmitriid 4y ago
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.
- 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.