This discussion is archived
2 Replies Latest reply: Nov 23, 2012 2:19 PM by Osama_Mustafa RSS

column level stats

975791 Explorer
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points