Optimizing SQL Performance

Optimizing SQL Performance

Asante Kotoko SC HD 0:51:42


Optimizing SQL Performance
all slots codes
all slots codes . 1747 Video
Followers
272826
7415 views
74
2
Date of publication:
20.07.2018 16:01 20.07.2018 16:01
Duration:
0:51:42
Source Video:
https://youtube.com/watch?v=VCJTVk4xZIs

Description:

Held on July 12 2018 In Julys 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

Optimizing SQL Performance

Optimizing SQL Performance

Similar Video