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!
we are facing a performance issue with below query : It takes 28 secs without using "ORDER BY dbms_random.value" at end. but when we use : "ORDER BY dbms_random.value" at end - it takes 26 minutes. Ideally it should be under a minute.