Beas - Adjust query

I need to adjust this query below. This occurs in any database of all customers. As yesterday's monitoring was run 637 times, if you look at the amount of Reads that are read pages each page contains 8kb. 15545617 * 8 KB = (124,364,936 / 1024) = 121.4501328125 MB 121.4501328125 / 1024 = 0.1186 GB.

This query is executed in the terminal in the option below.Here is the link to the Beas debughttp://www.beascloud.com/docs/beasscreen/20220209_124400_ZGVidWcuaHRtbA==.html

We can observe the conversion of data in the where clause so that SQL Server does not use the index by scanning the entire table to bring up the record.

For more performance, there can be no conversion in the data joins or filter.Below are the numbers after removing the conversion.The query starts running at 0ms.