explain plan selectivity

Roger25

Member²
Hi,

The Estimator part of Cost-Based Optimizer, generates three types of measures: selectivity, cardinality and cost.
I want to know, in the execution plan of a SQL statement in PL/SQL Developer (so when we press F5), how can we add the selectivity column? At Settings, I don't see a selectivity column, but there are those of Cost and Cardinality.

How can we see the selectivity of a particular SQL statement?

Thank you.
 
Last edited:
Back
Top