How to improve this procedure (Part 2)

This is an update (to https://answers.sqlperformance.com/questions/4799/how-to-improve-this-procedure.html#comment-4810) after implementing the suggestions of @SDyckes2 to build an #TempTable inside the procedure.

Further improvements (seemed) to result from adding PK to the #temptables that the input parameters were inserted into BUT performance (seemed) to diminish from adding a PK to the internally created #TempTable.

Nonetheless I still have two (seeming) problems in which the Est. Rows vs. Actual Rows differ (by 10x underestimated for the insertions into #TempTable and 140X overestimated for the data output).

Thanks in advance for any and all suggestions.

avatar image By MikeS 1 asked Nov 13 at 01:03 AM
more ▼
(comments are locked)
10|10000 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.