1.

What Do High Confidence, Low Confidence And No Confidence Mean In Explain Plan?

Answer»

Explain gives the execution strategy means what are the different steps that the query will go through.
HIGH CONFIDENCE: STATISTICS are collected.
LOW CONFIDENCE: Statistics are not collected. But the where CONDITION is having the condition on INDEXED column. Then estimations can be BASED on sampling.
NO CONFIDENCE: Statistics are not collected and the condition is on non indexed column.

Explain gives the execution strategy means what are the different steps that the query will go through.
HIGH CONFIDENCE: Statistics are collected.
LOW CONFIDENCE: Statistics are not collected. But the where condition is having the condition on indexed column. Then estimations can be based on sampling.
NO CONFIDENCE: Statistics are not collected and the condition is on non indexed column.


Discussion

No Comment Found

Related InterviewSolutions