May 12, 2017 at 11:33 am
If I have 50 different statements in the batch within a huge SP, and a bunch of Missing Indexes are shown for many of the statements and in most of the sections of the Query Exec. Plan (actual exec plan) it says:
Query cost (relative to the batch): 0%
Question: should I even bother at all about considering Missing Indexes for the
statements that have cost of 0% relative to the entire SP ?
Likes to play Chess
May 12, 2017 at 11:43 am
VoldemarG - Friday, May 12, 2017 11:33 AMIf I have 50 different statements in the batch within a huge SP, and a bunch of Missing Indexes are shown for many of the statements and in most of the sections of the Query Exec. Plan (actual exec plan) it says:
Query cost (relative to the batch): 0%
Question: should I even bother at all about considering Missing Indexes for the
statements that have cost of 0% relative to the entire SP ?
I vote no, at least as far as your stored procedure is concerned. Often I'll read advice that we shouldn't just add missing indexes without understanding their impact.
This DOES NOT mean that other processes in your system will not benefit from these missing indexes but in the context of your stored procedure I think your 0% cost speaks for itself.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply