Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

>It takes a single query and suggests indexes for it. A good one would take a mix of queries and suggest a set of indexes, also considering the impact on write speed of additional indexes (table updates often need to update indexes, too)

This is my pet peeve with SQL Server SSMS will give you a missing index suggestion and cost... the problem is inexperienced people will take the suggestion as is and create way too many highly specialized indexes over time.



Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: