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
| 
