Query taking more time to split,compare using regexp_substr() function

Summary

Query taking more time to split,compare using regexp_substr() function

Content

Hi ,

 

i have a report to get goal approvers names w.r.t. goal if pending with approvers.  HRC_TXN_DATA table has a column having goal ids which are submitted to approvals.So i need to put in condition on that column.but there column value is comma seperated string.

Ex : Attributte10 value is '300000016429008,300000016429011,300000016429029,300000016429026,300000016429020,300000016429023'

 

 So i need to keep join like this.

 AND HG.previous_state_goal_id in (txnd.ATTRIBUTE10)

 

 So i got some examples quaries using  

 select * from emp where ename in (