Hi Gurus,

Sorry for the late reply, attaching the actual execution plan for your reference. The query was generated from a BI tool that's the reason why its got 3part 4part names in the column, however, ill accept your suggestion and will work with the BI team on this.

All the columns in the where conditions of the SQL statements have indexes defined on them. if u have any more questions please let me know.

Thanks