---------------------------------------------------

--The underlying IV Not working, kindly help

---------------------------------------------------

CREATE VIEW IV_MMB_REPORT_2 WITH SCHEMABINDING AS

SELECT DT1.DT, DT1.DT_KEY,

SUM(isnull(Ag.BLNC_AMNT,0))[BLNC_AMNT] , G2.GOGRPHY_KEY ,COUNT_BIG(*)[COUNT]

...

while creating IV i have allready removed params and NOLOCK, but still my base query is not reading from IV

Lowell, Thanks for this approach

But still query is taking 60 secs

earlier it was taking 3 mins

anything else we can do in order to tune it??

PFA the New execution PLan

PFA, Actual plan

PFA, Execution Plan