Oracle SQL Performance Tuning 

Introduction of the Author - Mandar Mulay

Introduction to Oracle SQL Performance Tuning - Part 1

Introduction to Oracle SQL Performance Tuning - Part 2

Introduction to Understanding Necessity of SQL Tuning

Understanding Demography of Tables 1 - Part 1

Understanding Demography of Tables 1 - Part 2

Understanding Demography of Tables 2

Char Vs Varchar - Part 1

Char Vs Varchar - Part 2

All 6 clauses of Select Statement - Part 1

All 6 clauses of Select Statement - Part 2

All 6 clauses of Select Statement - Part 3

The Flow of Clauses Execution

Performance Impact of Where vs Having Clause - Part 1

Performance Impact of Where vs Having Clause - Part 2

Performance impact of Distinct, Group By and Count - Part 1

Performance impact of Distinct, Group By and Count - Part 2

Benefits of Exists Operator 1

Benefits of Exists Operator 2

Course Introduction - Oracle SQL Performance Tuning Overview

Course Syllabus - Oracle SQL Performance Tuning Overview

Data Types in Oracle

Practice Quiz: Understanding Demography of Tables

Practice Quiz: Data Types And Char Vs Varchar Datatypes from Performance Angle

Practice Quiz: Understanding Necessity of SQL Tuning

Graded Quiz: Understanding Necessity of SQL Tuning

Understanding Necessity of SQL Tuning

Introduction to Query Optimization Techniques

Compilation and Execution Part 1

Compilation and Execution Part 2

Compilation and Execution Part 3

Bind Variables 1

Bind Variables 2

Explain Plan part 1

Explain Plan part 2

AutoTrace Part 1

AutoTrace Part 2

Explain Plan - Compilation

Practice Quiz: Query Compilation & Execution

Practice Quiz: Tracing Query Execution Techniques

Graded Quiz: Tracing Query Execution Techniques

Tracing Query Execution Techniques

Introduction to Indexing Strategies

Introducing Indexes 1

Introducing Indexes 2

Introducing Indexes 3

Bitmap Index Part 1

Bitmap Index Part 2

B-Tree Index Part 1

B-Tree Index Part 2

Composite Index 1

Composite Index 2

Function-Based Index part 1

Function-Based Index part 2

Bitmap Index

Practice Quiz: Introducing Indexes

Practice Quiz: Bitmap Index

Practice Quiz: Query Optimization - Indexes

Graded Quiz: Query Optimization - Indexes

Query Optimization - Indexes

Introduction to Performance Tuning Tools and Techniques

Understanding Hints Part 1

Understanding Hints Part 2

Understanding Hints Part 3

Inline Views Part 1

Inline Views Part 2

Temporary Tables 1

Temporary Tables 2

Common Table Expression Part 1

Common Table Expression Part 2

Materialized Views - Part 1

Materialized Views - Part 2

Materialized Views - Part 3

Materialized Views - Part 4

Conclusion to Oracle SQL Performance Tuning

Understanding Hints

Common Table Expression

Practice Quiz: Understanding Hints

Practice Quiz: Inline Views

Practice Quiz: Temporary Tables

Practice Quiz: Common Table Expression

Practice Quiz: Materialized Views

Graded Quiz: Performance Tuning Tools and Techniques

Query Optimization - Hints, Inline Views & Temporary Tables

Query Optimization - Common Table Expressions & Materialized Views