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!
hi I have a query where in I have used 'not in ' construct It takes a lot of time .. any other way to get the result faster? e.g. select custno from cust_mast where custno not in (select custno from other_mast) please help
Oracle 12cR1 to 19c is a major release jump, as such it would probably be wise to perform full regression testing. However, it's your database and you can choose whatever level of testing and/or validations you deem fit.
Hi,
I agree with Wesley on the testing part. With regards to testing performance and ensuring performance stability I encourage you to look at the slides from a presentation my fellow Product Manager, Mike Dietrich gave a little while ago:
https://mikedietrichde.com/slides/
Search for:
Seminar 3 – Performance Stability, Tips and Tricks and Underscores
Regards,
Daniel