An Important Usage of col_usage$ view

(Vivek Sharma) COL_USAGE$ view is used internally by the optimizer when gathering statistics on columns. An option method_opt under dbms_stats control the use of this view. When method_opt is specified as ‘For all columns size auto’ (default in 10g), this view is used to get the information of each

Read More - Register for Free Membership