Procedure taking long time to exeucte


This SP taking long time to get results. Basically in the main select query I am using one view and in that view i am using one scalar function. That causing the problem and I can't avoid that function call in the view. Is there any way I can increase the performance of this SP.


avatar image By Sunil 1 asked Dec 12, 2016 at 11:59 PM
more ▼
(comments are locked)
avatar image Aaron Bertrand ♦ Jan 08, 2017 at 05:13 PM

The expensive index scan in the SELECT TOP 1 query (the one with the estimated cost of 28.0% relative to the batch) is caused by an RTRIM() operation against the ACCT_ID column in dbo.IVW_ACCT. Why is this RTRIM() operation necessary?

10|10000 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.

Follow this question



asked: Dec 12, 2016 at 11:59 PM

Seen: 54 times

Last Updated: Jan 08, 2017 at 05:13 PM