2 Replies Latest reply: Nov 23, 2012 4:19 PM by Osama_Mustafa RSS

    column level stats

    975791
      Hi,

      Version 11.2.0.1

      I am asked to do column level stats on a table which is not a partartition table.

      I68-SQL> desc wmgr.re_service_hist
      Name Null? Type
      ----------------------------------------- -------- ----------------------------
      JOB_ID NOT NULL NUMBER(10)
      OPTION_ID NOT NULL NUMBER(10)
      OPTION_NAME NOT NULL VARCHAR2(50 CHAR)
      OPTION_VALUE NOT NULL VARCHAR2(4000 CHAR)
      VALUE_ORDER NOT NULL NUMBER(38)

      Usually we do table level stats.what is use of column level stats over table level stats?
      when to do column level stats?How to do it?

      Thanks