Hi All,

I have the actual Exec plan attached.

This the worst case (With max.data load condition)

(i.e

DECLARE @return_value int

EXEC @return_value = [dbo].[pr_Case_Get_Cases]

@USER_NAME = N'ashahi',

@USER_ROLE = N'pom',

@BUSINESS_UNIT = N'bmg',

@OPENONLY = 0

SELECT 'Return Value' = @return_value

)

Thanks,