Understanding what a large gap between estimated and actual rows in an execution plan indicates.
In an execution plan, an operator shows an estimated row count of 5 but an actual row count of 500,000, and the query is slow. What is the MOST likely root cause and appropriate fix?