My THREE rules for SQL TUNING
Follow me! blog: https://connor-mcdonald.com twitter: / connor_mc_d The Podcast! https://podcasts.apple.com/au/podcast... https://open.spotify.com/show/5dqVVft... Subscribe for new tech videos every week Other social media channels here: https://linktr.ee/connor A free Oracle database forever ?! Oh yes indeed! https://www.oracle.com/cloud/free Music: Night Owl (Broke For Free), Kevin Mcleod (incomptech), Dyalla #oracle #sql #performance
▶︎
Supercharged data loading in 23c/23ai !
▶︎
The five-step guide to SQL tuning | CloudWorld 2022
▶︎
Explaining Explain Plans
▶︎
The KEEP clause will KEEP your SQL queries SIMPLE!
▶︎
The NoSQL Lie That Keeps Developers Overbuilding
▶︎
Explaining the Explain Plan: Interpreting Execution Plans for SQL Statements
▶︎
Turing Award Winner: Disagreeing with Google, Postgres, Future Problems | Mike Stonebraker
▶︎
Top PL/SQL Tips In Just One Hour
▶︎
Real-Life SQL Tuning: From Four Minutes to Eight Seconds in an Hour
▶︎
Count Millions of Rows Fast with Materialized Views: Databases for Developers: Performance #6
▶︎
Wait events & DB Time ( Franck Pachot at POUG Workshop)
▶︎
Real-World Performance - 15 - Index Contention
▶︎
Taking back control of optimizer statistics
▶︎
A tour of the Oracle Database Block
▶︎
What to Look for in Execution Plans: Databases for Developers: Performance #3
▶︎
Harnessing the power of Oracle Database optimizer hints | CloudWorld 2022
▶︎
How to Use SQL Plan Baselines and SQL Profiles
▶︎
Analysis of a Couple AWR Reports - OTW2018
▶︎
SQL Indexes (Visually Explained) | Clustered vs Nonclustered | #SQL Course 35
▶︎