Oracle SQL Tuning Case Study 13 - Avoid Merge Join Cartesian

If you have a KINDLE EDITION Subscription, you can read the below SQL Tuning & SQL Beginner's books for free:

1) Oracle SQL Performance Tuning and Optimisation: Its all about the Cardinalities
https://amzn.to/3GUDhld

2) Oracle SQL and PL/SQL Performance Tuning: Query Tuning and Optimisation
https://amzn.to/3VrcxwM

3) SQL: 3 books in 1 : Learn SQL Basics for beginners + Build Complex SQL Queries + Advanced SQL Query optimisation techniques
https://amzn.to/3gBc9go
--------------------------------------------------------------------------------------------------------------------------------------------------------------
Below are some of the good reference books to read for SQL Tuning.

1) SQL TUNING (COVERS ORACLE,DB2 & SQL SERVER)
https://amzn.to/3F9SBsB

--------------------------------------------------------------------------------------------------------------------------------------------------------------

Materials For This Videos can be found below:
https://drive.google.com/drive/folder...

--------------------------------------------------------------------------------------------------------------------------------------------------------------

Visit the "Oracle SQL Performance Tuning - From Scratch To Tuner" Course On Udemy To Learn SQL Tuning From Scratch. You Can Use The Below Link To Get Through The Course Details.

Use the Link Below To Avail This Course At a Special Price Of INR Rs. 499.
https://www.udemy.com/course/sql-tuni...

Do Share Your Valuable Feedback And If There Are Any Doubts With Respect To The Course, Do Share In The Comment Section. We, Will, Address It.

Facebook Page:   / virsess  
LinkedIn Page:   / virsess  

Udemy Course Module:

Introduction
Types Of Indexes
RBO V/S CBO
Execution plan
Access Methods
Join Methods
Cardinality
Histograms
Fundamental Approach For Query Tuning
Hints
Baselines
Useful Scripts
Case Studies
--------------------------------------------------------------------------------------------------------------------------------------------------------------