Plan indicates 917 records inserted. checking the table no records inserted. Why would this be??
I have a user submitting a job that is in the top sql each time it is run. When I look at the plan in each case, I can see at the end of the steps it inserts 917 rows of data in a particular table. This is not true. I truncated the table and expected to see 917 records inserted. No records where inserted. Why would this be??
The 917 rows in the submitted plan is the optimizer estimate. You would need to run the query with Actual Plan on, or ideally directly from Plan Explorer, for us to say why no rows were inserted at run time.