Rajesh Sinha

• May 29th, 2015

 

While Analyze execution Plan , Look for following :
a) driving Table
b) Join Order
c) join Method
d) Unintentional cartesion Product
e) Loops - Nested, Merge sort , Hash Join
f) Full Table Scan
g) Index available but not used
h) access Paths.

ajit

• Jun 19th, 2017

 

In explain plan we need to check
1)Driving table
2)Join order
3)Join method
4)Cartition product
5)Full table scan
6)Unused index
7)Access Path