June 9, 2017 at 5:06 am
krishna83 - Friday, June 9, 2017 4:59 AMI raised this question to improve performance of the query.It would be more help full if you give based on execuiton plan,
I think there's plenty of scope for improvement.
Firstly, can you post up an actual execution plan, rather than estimated? You can easily discard the results by running them into a temp table, like this:
...
ENCNT_VIS_KEY,
BILL_STATUS
INTO #Temp
FROM (
...
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
June 9, 2017 at 5:57 am
Please find attached actual execution plan of the query.
June 9, 2017 at 6:07 am
krishna83 - Friday, June 9, 2017 5:57 AMPlease find attached actual execution plan of the query.
This is an estimated plan. To get the actual plan, select [Include Actual Execution Plan] from the SSMS menu strip and run the query.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply