Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Set num distinct value of a column

LuisMCeballosApr 26 2016 — edited Apr 27 2016

Hello, query on USER_TAB_COL_STATISTICS (Oracle 12c) returns NUM_DISTINCT = 0 for all columns (table with no data. It's ok). Is it possible gather statistics to change this value? I don't know data distribution, just number of distinct values, therefore histograms shouldn't be applied, right?

Thank you very much.

Best regards.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 25 2016

Added on Apr 26 2016

#general-database-discussions

15 comments

3,032 views