Oracle histogram delete

rid of histogram
get rid of a histogram
histogram delete


exec dbms_stats.gather_table_stats(user, 'anuj', method_opt => 'for columns n size 1', cascade => true,NO_INVALIDATE => FALSE );


table name is anuj


METHOD_OPT => 'FOR COLUMNS X SIZE 1'

and NO_INVALIDATE => FALSE. dependent cursors will be invalid immediately after stats have
been gathered.