News for hackers. Stuff that matters.
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)

There are no comments on this comment yet.