Optimizing SQL Performance
Held on July 12 2018
In July's session we mainly looked at performance. Highlights include:
1:30 How does the database process subqueries?
5:20 Performance: comparing insert ... select to create tmp table, insert select from tmp; DDL in PL/SQL; dynamic SQL problems
12:45 18c private temporary tables; tables specific to a session; DDL you can rollback across!
21:00 Improving update performance: things to watch for; insert vs. update; "join-update" - create a view instead; create table as select "update"
34:05 Analytic function performance: first_value non-determinism; min keep vs first_value; computing function in a subquery; indexes for analytic functions
AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists.
https://asktom.oracle.com/
Oracle Developers portal: https://developer.oracle.com/
Sign up for an Oracle Cloud trial: https://cloud.oracle.com/en_US/tryit
music: bensound.com
On this page of the site you can watch the video online Optimizing SQL Performance with a duration of hours minute second in good quality, which was uploaded by the user Oracle Developers 20 July 2018, share the link with friends and acquaintances, this video has already been watched 34,708 times on youtube and it was liked by 376 viewers. Enjoy your viewing!
