Home » RDBMS Server » Server Administration » histograms in dbms_stats.gather_table_stats (Oracle Database 19c Enterprise Edition Release 19.0.0.0.0)
histograms in dbms_stats.gather_table_stats [message #681677] Fri, 14 August 2020 17:16 Go to next message
wtolentino
Messages: 320
Registered: March 2005
Senior Member
usually i use the default when i am using the dbms_stats.gather_table_stats package to collect the statistics.

for example:
 execute dbms_stats.gather_table_stats('HR','EMPLOYEE');
then i was been asked this question "does using a default on dbms_stats.gather_table_stats creates a histogram and if so how?".

how does dbms_stats.gather_table_stats creates a histogram?

thank you,
warren
Re: histograms in dbms_stats.gather_table_stats [message #681678 is a reply to message #681677] Fri, 14 August 2020 23:25 Go to previous message
Michel Cadot
Messages: 67560
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
does using a default on dbms_stats.gather_table_stats creates a histogram and if so how?".

It depends on your default gathering method (as you specified none):
SQL> select dbms_stats.get_param('METHOD_OPT') from dual;
DBMS_STATS.GET_PARAM('METHOD_OPT')
---------------------------------------------------------
FOR ALL COLUMNS SIZE AUTO

Quote:
how does dbms_stats.gather_table_stats creates a histogram?

Doc: https://docs.oracle.com/en/database/oracle/oracle-database/19/arpls/DBMS_STATS.html#GUID-CA6A56B9-0540-45E9-B1D7-D78769B7714C


[Updated on: Fri, 14 August 2020 23:25]

Report message to a moderator

Previous Topic: no listener
Next Topic: UPDATE taking a long time, indication disappeared
Goto Forum:
  


Current Time: Tue Dec 01 15:44:59 CST 2020