2 Replies Latest reply on May 11, 2017 10:21 AM by bekkerza

    DPA - SQL - Has plan(s) that indicate a full table scan.


      I found on a couple of instances, DPA reports plans with full table scans, but opening the indicated plan, nothing but seeks and index scans appear, and all seem good.

      Yet, DPA still recommends adding an index because of the "full table scan" which does not exist.


      Am I missing the DPA recommendation here or has anyone seen the same?

      From DPA. I've cross referenced the XML for this plan on other pastetheplan sites and same result, no indication of a full table scan.