Replicated a particular string and create new column

Hi, Lenoj!

You can rewrite query, to use cross apply and look the execution plan. I need to know a lot of things to optimize query.

Try rebuild statistics.