SQL need to be optimized

[p655279]

Hi all,

I have a sql like this:

Select *
from table_X
where col_a || col_b
in
(select col_c || col_d
from table_ Y);

The syntax seems be OK, however it takes very long to complete, anyone knows why? is there any way to improve this SQL to achieve same purpuse?

Thanks