CP-Gather schema stats program

Hi All,

Greetings. Hope everyone is doing great.

In our environment for some seeded schemas  we run gather stats program daily with parameter like below

PO, 0, 4, NOBACKUP, , LASTRUN, GATHER AUTO, , N

Recently one of our program was taking more time to complete so when we run sql tuning advisory it recommended sql profiles . Accepted the profile. When checked the profile hint it basically did column_stats

COLUMN_STATS("XXXXX"."XXXXX", "OLD_COA_ID", scale, length=4 distinct=9 nulls=0 min=50411 max=51809)

COLUMN_STATS("XXXXX"."XXXXX", "LEDGER_ID", scale, length=3 distinct=11 nulls=0 min=4030 max=6251)

COLUMN_STATS("XXXXX"."XXXXX", "NEW_COA_ID", scale, length=4 distinct=3 nulls=0 min=51089 max=52129)