Parsing multiple missing index recommendations #1
Description
In newer versions of SQL Server, execution plans can provide multiple missing index recommendations. Have you found a way to update your scripts to produce accurate and complete output for such plans? I can’t figure out how to separate them -- if there are missing indexes on two tables in one plan, I end up with the columns from them combined or only get the first one (because of the “[1]” in the parameters passed to stmt_xml.value(). Any ideas?