Hello Team,
Recently in our production environment we are getting the following alert “Query Targeting: Scanned Objects / Returned has gone above 1000” continuously at least twice a week but when our team checks the profiler during the time of alert all the queries execution time was not more than 50ms and also all the queries which were running during the time of alert was insert queries.
Even in performance advisor I didn’t get any suggestion to add new index based on the generated alerts. Can you please help me with this since it is production platform we are worried about this alert