Finally the issue had nothing to do with data encryption.
The actual issue came from the fact that the statistics of the database were out of date after a big data migration. We updated them using EXEC sp_updatestats
and after that the query was executed using the expected execution plan and with expected performance.
CLICK HERE to find out more related problems solutions.