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