ITPUB

Sep 13, 2016 · Backend Development

Auto‑Detect Useful Column Groups in Oracle 12c to Improve Query Plans

This guide shows how to use Oracle 12c's DBMS_STATS.SEED_COL_USAGE and REPORT_COL_USAGE to automatically identify useful column groups, create extended statistics, and verify the impact on execution plans with concrete SQL examples.