What is index join confidence

Database
Enthusiast

What is index join confidence

Hi All,
I have a huge query which joins three tables by left join on NUPI.
when i run the explain plan i get the word index join confidence.
I just need to know whether the optimizer is using mu NUPI for the query
or not.
Please help...

3 REPLIES
Enthusiast

Re: What is index join confidence

Even I am trying to understand what the meaning of the term "index join confidence".

It will be great if any of the Teradata Gurus can explain if this is good confidence level.

Enthusiast

Re: What is index join confidence

You see the 'Index Join Confidence' clause when the join condition contains unique undexes...

Enthusiast

Re: What is index join confidence

Hi Ragav,

Index join confidence will appear in instances when an index (with or without statistics) is present on one side of the join but no index or statistics are on the other side.

pls refer for confidence levels: 

http://www.teradatamagazine.com/v09n02/tech2tech/did-you-know/

Suresh