0 - 2 of 2 tags for optimizer output

 

Whether you write your own code or it is generated for you, this is a topic that is essential for business users who run SQL queries.

Hi Guys,
 
I have a doubt regarding the confidence levels of the optimizer in the explain plan.
 
Below is the scenario that i created:
1. Created 2 tables Location and Employee with unique primary indexes on EmpNo column