Thank you. 

Thank you. 

Please see attached executution plan for below query. It is taking 4 sec to run. What I need to change in this query. How...

/****** Object: View [dbo].[VW_STG_ITEM]  Script Date: 03/22/2017 13:57:15 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

Alter VIEW [dbo].[VW_STG_ITEM]
AS
SELECT i.item_id       ...