I am concerned about the row estimates

jmalley84 2017-05-08 21:30:51

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.