What are Optimizer Statistics? Databases for Developers: Performance #2
To choose an execution plan, the optimizer needs to estimate how many rows it'll read from each table.
But what does it base these estimates on?
The table statistics!
Watch this video to learn what these are and how they affect execution plans.
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 are Optimizer Statistics? Databases for Developers: Performance #2 канала The Magic of SQL
But what does it base these estimates on?
The table statistics!
Watch this video to learn what these are and how they affect execution plans.
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 are Optimizer Statistics? Databases for Developers: Performance #2 канала The Magic of SQL
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
What to Look for in Execution Plans: Databases for Developers: Performance #3How do nested loop, hash, and merge joins work? Databases for Developers Performance #7Oracle statistics | Database Performace tuningPreparing For A Data Engineering Interview: How To Design A Data Warehouse For.A Food Delivery AppCount Millions of Rows Fast with Materialized Views: Databases for Developers: Performance #6The 7 steps of machine learningWhy Isn't My Query Using an Index? Databases for Developers: Performance #5SQL Tutorial - PIVOTHow to Make Inserts, Updates, and Deletes Faster: Databases for Developers: Performance #8How to Read an Execution Plan: Databases for Developers: Performance #1How to Learn to Code - Best Resources, How to Choose a Project, and more!What is the use of histogram in Oracle DatabaseOracle SQL Optimizer Overview | Query Optimizer ConceptsWhat is the purpose of gather stats in OraclePython Tutorial for Absolute Beginners #1 - What Are Variables?7 Amazing Science Gadgets!PostgreSQL performance in 5 minutesAWR Report Analysis - How to Read AWR Report? Performance Tuning and Troubleshooting - PT 2