Well, this is the most broader topic. With no specific thing being said, Tune SQL simply means "make it runs faster!".
So, here there is no much to say. Practice counts much more than theory knowledge for this one.
What I would recommend here is the same I said for 11g exam: consider here the access methods can be made during an explain plan and tune them using database parameters, statistics collections and indexes that can help.
The new Adaptive Statistics and Adaptive Plans features in 12c should also be focused specially as it is an Upgrade Exam. So take also a look at DBMS_SPD package and SQL Plan Directives.
Path to Documentation:
Database PL/SQL Packages and Types Reference -> DBMS_SPD
Oracle Database SQL Tuning Guide-> Query Optimizer Concepts
Oracle Database SQL Tuning Guide-> Optimizer Statistics Concepts
Click here to go back to the Main OCM 12c Preparation page.
Have you enjoyed? Please leave a comment or give a 👍!
