What to Look for in Execution Plans: Databases for Developers: Performance #3
You've got the plan for your SQL statement. But what do you need to change to make it faster?
This video shows you how to add I/O information to the plan. This enables you to see which steps consume the most resources, and thus where you need to focus your tuning efforts.
Need help with SQL?
Ask us over on AskTOM: https://asktom.oracle.com
Twitter: https://twitter.com/ChrisRSaxon
Daily SQL Twitter tips: https://twitter.com/SQLDaily
All Things SQL blog: https://blogs.oracle.com/sql/
Test your SQL Skills on the Oracle Dev Gym: https://devgym.oracle.com/
============================
The Magic of SQL with Chris Saxon
Copyright © 2020 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Видео What to Look for in Execution Plans: Databases for Developers: Performance #3 канала The Magic of SQL
This video shows you how to add I/O information to the plan. This enables you to see which steps consume the most resources, and thus where you need to focus your tuning efforts.
Need help with SQL?
Ask us over on AskTOM: https://asktom.oracle.com
Twitter: https://twitter.com/ChrisRSaxon
Daily SQL Twitter tips: https://twitter.com/SQLDaily
All Things SQL blog: https://blogs.oracle.com/sql/
Test your SQL Skills on the Oracle Dev Gym: https://devgym.oracle.com/
============================
The Magic of SQL with Chris Saxon
Copyright © 2020 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Видео What to Look for in Execution Plans: Databases for Developers: Performance #3 канала The Magic of SQL
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
How to Create Database Indexes: Databases for Developers: Performance #4How to Read an Execution Plan: Databases for Developers: Performance #1What are Optimizer Statistics? Databases for Developers: Performance #2How to Find Slow SQL: Databases for Developers: Performance #9Why Isn't My Query Using an Index? Databases for Developers: Performance #5A Story of Indexes and Full Table Scans: Finding All the Red Sweets Part 1How to Make Inserts, Updates, and Deletes Faster: Databases for Developers: Performance #8Using SQL Monitor to Interpret Execution Plans in OracleHow to Generate an Execution Plan in OracleSQL Server Execution Plans - Part 1Index and Execution Plan basicsHow Does the Phyiscal Location of Rows Affect Indexes?: Finding All the Red Sweets Part 2Read Oracle SQL Execution Plan | DBMS XPLANUnderstanding Oracle Optimizer Statistics with Karen Morton hd720Query Tuning 101: How to Compare Execution PlansScenario Based Question | Oracle Database Tricky Interview QuestionsSQL Index |¦| Indexes in SQL |¦| Database IndexHow To Read SQL Server Execution Plans