Viewing 8 posts - 1 through 8 (of 8 total)
Here's the plan, zipped.
January 20, 2020 at 3:28 pm
This was removed by the editor as SPAM
January 17, 2020 at 8:22 pm
And now the second try:
January 17, 2020 at 8:20 pm
Attached is an actual plan and the current entire query. We did make some changes based on some of the feedback, so you'll see it's different than the original.
January 17, 2020 at 8:19 pm
I love all the input everyone, really - lots of information to digest here. I'll try and get that information (and the actual execution plan) asap.
My god, why didn't I...
January 17, 2020 at 8:03 pm
There is an index for ServiceDate on that table, although that table has a ton of indexes on it. We're very likely trying to do too much here (indexes with...
January 16, 2020 at 8:03 pm
It's all in that link: https://www.brentozar.com/pastetheplan/?id=SJF21m0lU
INSERT INTO @retTable
SELECT c.ClaimID, cd.ServiceCode, c.ServiceDate, cd.ServiceQty, c.CareProviderID, ISNULL(cd.DiagnosticCode, c.DiagnosticCode), c.SpecialtyCode AS Speciality,
sg.GroupCategory AS ServiceCodeGroupCategory, 0,...
January 16, 2020 at 6:50 pm
Gah! Sorry, didn't mean to post twice - site timed out during the original post.
January 16, 2020 at 5:53 pm
Viewing 8 posts - 1 through 8 (of 8 total)