regex - Oracle SQL replace some string in a string FAST -

regex - Oracle SQL replace some string in a string FAST -

i have simple problem: replace xx_fistname lastname (maybe dr. or phd trash) firstname lastname

now using regexp replace:

trim(regexp_replace(lower(vhc.name),'xx_|dr|\.|\,|phd|jr','')

but really slow... can give me hint how can replace faster? have much info compare , other functions on these info , takes hours.

a reduced one.

trim(regexp_replace(lower(vhc.name),'xx_|[dj]r|[.,]|phd','')

sql regex oracle replace query-optimization