I work on sql server 2012 I face issue this query when run is very slow so how o enhance itto be more faster
query and execution plan exist on link below :
https://www.brentozar.com/pastetheplan/?id=S1wEKwf5O
so how to enhance it to be more faster
it too much time may be reach to one hour
and
script ddl and data dmlexist here below :https://www.mediafire.com/file/hz74ca3z08xiic8/getscriptfinalresult.sql/file