Oracle SQL Performance Tuning - From Scratch To Tuner

Name: Oracle SQL Performance Tuning - From Scratch To Tuner
Rating: 4.2 (109 reviews)

Analyze & Interpret Poor Performing SQL From Scratch And Fix Them With Best Plan

Created byVirsess !!!

Last updated 1/2023

English

English [Auto],

What you'll learn

Analyze SQL Query From Scratch By Verifying Optimizer Is Undertaking Desired Path By Reading And Interpreting Execution Plan
Fix Poor Performing SQL Query Involving Non-Joins, Joins With Two Tables, Joins With Multiple Tables With Best Plan By Making Use Of Indexes, Hints & Baselines
Interview Ready On Joins/Histograms/Access Methods/Execution Plan
19 Cases of poor performing SQL's and their fixes

Course content

10 sections • 26 lectures • 3h 54m total length

Course Contents2:07
Before We Start4:43
Summary0:14

Course Contents0:38
Explore the module on index types, including beta, bitmap, function based, index organized tables, cluster, and composite indexes, and learn the purpose and advantages of each.
Introduction To Indexes4:06
B-Tree index8:12
Bitmap Index4:42
Oracle's bitmap index optimizes queries on low-cardinality columns by converting values into bitmaps of zeros and ones, enabling fast bitwise operations and space-efficient data warehouse performance.
Function Based Index2:25
Index Organized Tables10:59
Explore index organized tables stored in a B3 structure where data and index share storage, enabling fast retrieval via the primary key and including non-key columns, with creation constraints.
Cluster Index2:45
Explore cluster indexes that cover multiple tables sharing a common column. Create a cluster and a cluster index on the shared department column, and see how it enables efficient queries.
Composite Index3:13
Summary1:11
Explore Oracle SQL performance tuning by examining bitmap index, function-based index, index-organized tables, cluster index, and composite index.

Requirements

Basic SQL Pre-Requisite

Description

This Course Will Help You To Tune SQL Queries With Respect To Oracle Database 11g Starting With The Basic Pre-Requisite For SQL Tuning Along With Tips And Tricks. After Completing This Course, You Will Be Able To Tune Most Of The SQL Queries With Non-Joins, Joins With Two Tables And Joins With Multiple Tables.

Who this course is for:

Oracle DBA, SQL Developer, DBA's

Oracle SQL Performance Tuning - From Scratch To Tuner

What you'll learn

Explore related topics

Course content

Introduction3 lectures • 7min

Types Of Indexes9 lectures • 38min

RBO V/S CBO4 lectures • 18min

Execution Plan4 lectures • 45min

Access Methods1 lecture • 31min

Joins1 lecture • 19min

Statistics And Histograms1 lecture • 27min

Fundamental Approach For Query Tuning1 lecture • 16min

Hints And Baselines1 lecture • 28min

Scripts & Case Studies1 lecture • 6min

Requirements

Description

Who this course is for: