need the review of plan and recommendations

cse005 2016-04-05 02:21:12

SQLkiwi 2016-04-05 19:25:19
With that number of dependant objects, there's not much to say except that they must all be maintained, and there are few options to affect what happens. Are you experiencing a performance or other type of problem? Check all the dependencies are actually required, I suppose.

The anonymized plan makes it hard to see exactly what the dependencies are though.

cse005 2016-04-05 23:24:37
They are time outs happening at the application when we try pull some reports and the above sp also runs to delete