Glossary

KEYCARD

Collects full key cardinality information. This tells the optimizer how many distinct values exist for each key prefix. For example, on a compound index (BRANCH_ID, ACCOUNT_TYPE, ACCOUNT_ID), KEYCARD records the number of distinct values for (BRANCH_ID), (BRANCH_ID, ACCOUNT_TYPE), and (BRANCH_ID, AC

Learn More

Related Terms