I am concerned about the row estimates

MOT_tablename are memory optimzed temp tables. durbability = schema_only tableName_MOT are memberoy optimzed tables durbability = schema and data

i have changed the pk nonclustered on the temp tables and it seems to have helped. It removed some sorting before any nested/merge joins. i think there is more to gain, but i think i am missing something. Whether it is code related or schema related. I can post the schema is this process if that helps.

avatar image By jmalley84 16 asked May 08, 2017 at 09:30 PM
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.

Follow this question



asked: May 08, 2017 at 09:30 PM

Seen: 209 times

Last Updated: May 08, 2017 at 09:30 PM