Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Oracle SQL : Mastering Oracle SQL Performance Tuning
Oracle Architecture
Introduction to Oracle Architecture (3:04)
Oracle Storage (5:50)
Oracle SGA (6:59)
Oracle Background Process (4:34)
Oracle PGA (3:21)
Oracle Terminology (3:04)
Physical and Logical Storage (8:56)
Explain/Execution Plan
Explain Plan and it's contents (6:47)
Generate and View the Explain Plan (13:17)
View Explain Plan and Statistics in SQL * PLUS (7:35)
Analyze the Explain Plan (17:56)
SQL Processing
Soft/Hard Parse (6:05)
SQL Statistics and Cardinality
Oracle Statistics (6:57)
Generate Statistics (13:17)
Importance of Cardinality (19:37)
Statistics/Cardinality Feedback (10:18)
Extended Statistics (9:30)
Histogram (8:12)
Index and it's Types
Index and its types (3:17)
B-Tree Index (11:22)
Descending Index (4:21)
Key Compressed Index (7:41)
Reverse Key Index (3:59)
Function Based Index (3:45)
B-Tree Clustered Index (3:19)
IOT Index (3:33)
Bit Map Index (5:59)
Oracle Access Methods
Access Methods (2:37)
Full Table Scan (4:03)
Index Fast Full Scan (4:04)
Index Full Scan (2:57)
Index Range Scan (5:41)
Index Unique Scan (3:52)
Index Skip Scan (3:39)
Oracle Joins
Joins Overview (3:20)
Nested Loop Join (5:59)
Sort Merge Join (5:20)
Hash Join (6:51)
Query Tuning Tips
Parallel Hint (3:45)
Append Hint (2:55)
CTAS Statement (4:06)
Union Vs Union ALL (3:48)
Multiple Scan Statements (3:37)
Expression on Index Columns (3:10)
Truncate Vs Delete (3:32)
Unnecessary Sort (2:23)
Bad Usage of * in Select (2:23)
Having in Group By (2:21)
Use of Alias (2:09)
Advanced Tuning Topics
Bind Peeking Problem (3:18)
Adpative Cursor sharing (Part 1) (14:04)
Adpative Cursor sharing (Part 2) (19:44)
Bind Aware Hint (10:16)
Dynamic Sampling (6:07)
Appendix: Oracle Installation 11g and 12c
Oracle 12C Installation (13:42)
Oracle 11G Installation (8:00)
Unlock HR Schema (7:09)
Installation of SQL Developer (6:21)
Installation of Training Schema (10:39)
CTAS Statement
Download
SQL_Tuning_CTAS.sql
Complete and Continue