3 ms·
> This is one of the feature that MS SQL Server has and it works very well. It can suggest indexes with a pretty good correctness. Not really: it's just a comm
by BrentOzar 5y ago
> This is one of the feature that MS SQL Server has and it works very well. It can suggest indexes with a pretty good correctness.
Not really: it's just a comma-delimited list of columns to consider indexing, sorted by the column order in the table. It just looks scientific to folks because they don't realize that. https://dba.stackexchange.com/q/208947/426 https://dba.stackexchange.com/q/208947/426
- polskibus 5y agoThank you very much for this insight about MS SQL! My point about building an indexing hint tool for auto-indexing in Postgresql still stands though - it could be great for cloud deployments.