|
|
|
Junior Member
 
Group: Forum Members
Last Login: 7/3/2008 3:49:29 AM
Posts: 22,
Visits: 21
|
|
if the explain plan shows Index Join Confidence for a particular join condition is it better than High Confidence. and also interested to know that how exactly optimizer uses Index Join Confidence, what is the criteria to choose that. is it ok that if one of the columns don't have stats on a particular join column in which the optimizer using Index Join Confidence.
dixon
|
|
|
|