LOW CONFIDENCE HIGH CONFIDENCE OF QUERIES

Database
Enthusiast

LOW CONFIDENCE HIGH CONFIDENCE OF QUERIES

Can someone explain me about what exactly LOW CONFIDENCE HIGH CONFIDENCE means
When I see Explain plan of queries I see this words in explain plan...

Thanks in advance...

Regards,
Ravi.
1 REPLY
Teradata Employee

Re: LOW CONFIDENCE HIGH CONFIDENCE OF QUERIES

See SQL Reference: Statement and Transaction Processing for a chapter on "Interpreting the output of EXPLAIN", including a section on "EXPLAIN confidence levels".