Creating a central repository for all methods to calculate optimizer statistics

Didier ROS

Hi

optimizer statistics are very important for the global performance of a database.

I think it would be interesting if we could have a central repository where we could find all the possible methods to calculate these statistics.

At the moment, we have to search among a lot of notes in the M.O.S.C.

top.gun

Is there something wrong with doco for statistics gathering?

http://docs.oracle.com/database/121/TGDBA/gather_stats.htm#BEIIGIHI

Didier ROS

Is there something wrong with doco for statistics gathering?

http://docs.oracle.com/database/121/TGDBA/gather_stats.htm#BEIIGIHI

Hi

Nothing wrong but it shows only the syntax of the commands.

In real world, we need advice and hints to find the right command to calculate statistics ( with or without histograms, on which columns...)

what about correlated statistics ?

I think it would be nice to have a unique location where we can find recommandations and practical experiences.

top.gun

Hi

Nothing wrong but it shows only the syntax of the commands.

In real world, we need advice and hints to find the right command to calculate statistics ( with or without histograms, on which columns...)

what about correlated statistics ?

I think it would be nice to have a unique location where we can find recommandations and practical experiences.

I gave the you wrong link see here:

http://docs.oracle.com/database/121/TGSQL/tgsql_statscon.htm#TGSQL336

The best practice is always stick with the default setting, unless the default is not right for you.

I think it would be nice to have a unique location where we can find recommandations and practical experiences.

This is exactly what the community is for.