SQL developer hangs when I try to run a query. How do I get rid of this?

Hello All,

I am running a sql query using sql developer, against Autonomous Data Warehouse (ADW) and it hangs. How do I get rid of this?

I have two tables, Merged_DS_Table (4.6 million records) and operation_list_16 (235 records).

And the query is

select * from Merged_DS_Table a, operation_list_16 b where a.CS_METHOD=b.CS_METHOD and regexp_like(a.CS_URI,b.CS_URI);

The above query, when run in sql developer hangs and that is because, regexp_like(a.CS_URI,b.CS_URI), tries to match the source_string a.CS_URI with each of the distinct search_pattern, b.CS_URI (155 patterns) in operation_list_16 table.