SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Slow performance when using REGEXP_REPLACE in ORDER BY

kovarJun 13 2019 — edited Jun 14 2019

Hi everyone,

I have a table with over 100 million rows that needs to be sorted in a way shown below:

A1.1

A1.2

- A1.2.1a

- A1.2.1b

...

A10.1

I have posted a question on this forum earlier before about this issue ( Ordering alphanumeric values ) and the community gave me a good solution with using REGEXP_REPLACE. It was simple and it did a good job, but with small volume of data.

Now I have problem with large volume of data, performance is really slow and I need some good brainstorming what can I do better.

Any kind of tip is going to be helpful.

Thanks for your time in advance!

- Kovar

Added on Jun 13 2019

#performance

15 comments

6,385 views