Selectivity from cardinality statistics

Cardinality statistics are computed by the Derby system and stored in the system tables.

For information on when these statistics get created or updated, see When cardinality statistics are automatically updated.

Derby can use cardinality statistics if all of the following are true:

Related concepts
Selectivity from hard-wired assumptions