February 22, 2018 at 2:44 pm
I'm looking into removing unnecessary query costs from execution plans and I came across a high cost query which has a function with RID (heap) lookup, I wanted to know how if possible it could be removed from the query plan please as this is a function which I'm dealing with?
Thanks in advance!
February 22, 2018 at 3:08 pm
Okay, could you answer this question with what you have posted?
February 23, 2018 at 2:08 am
tt-615680 - Thursday, February 22, 2018 2:44 PMI'm looking into removing unnecessary query costs from execution plans and I came across a high cost query which has a function with RID (heap) lookup, I wanted to know how if possible it could be removed from the query plan please as this is a function which I'm dealing with?Thanks in advance!
May I know for what is the purpose of using the function ? If you can achieve your desired output without using function, I think this issue can be resolved by yourself.
February 23, 2018 at 2:50 am
subramaniam.chandrasekar - Friday, February 23, 2018 2:08 AMtt-615680 - Thursday, February 22, 2018 2:44 PMI'm looking into removing unnecessary query costs from execution plans and I came across a high cost query which has a function with RID (heap) lookup, I wanted to know how if possible it could be removed from the query plan please as this is a function which I'm dealing with?Thanks in advance!May I know for what is the purpose of using the function ? If you can achieve your desired output without using function, I think this issue can be resolved by yourself.
The function gets triggered from the Application (front-end) and seems to run regularly from looking at the "execution count" column. I just want to know if there is a way from the RID (Heap) to be removed from the execution plan as it currently has a high operation cost.
February 23, 2018 at 3:05 am
tt-615680 - Friday, February 23, 2018 2:50 AMsubramaniam.chandrasekar - Friday, February 23, 2018 2:08 AMtt-615680 - Thursday, February 22, 2018 2:44 PMI'm looking into removing unnecessary query costs from execution plans and I came across a high cost query which has a function with RID (heap) lookup, I wanted to know how if possible it could be removed from the query plan please as this is a function which I'm dealing with?Thanks in advance!May I know for what is the purpose of using the function ? If you can achieve your desired output without using function, I think this issue can be resolved by yourself.
The function gets triggered from the Application (front-end) and seems to run regularly from looking at the "execution count" column. I just want to know if there is a way from the RID (Heap) to be removed from the execution plan as it currently has a high operation cost.
Yep I got it, You need to double check the usage of the columns so that the columns which are used in function can be avoided, which automatically resolves bookmark lookups in your execution plan.
Please refer below,
February 23, 2018 at 7:13 am
And again, you haven't given us anything to work with in order to help you. In fact, you haven't even asked what we might need.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply