Ankit Ashok Aggarwal wrote:post SQL & results that lead you to take this course of action.
We are planning to switch from automatic statistics gathering to manual statistics gathering for our oracle databases.
please share your view?
also do you have any tested script for same where we can implement manual statistics gathering for our oracle databases.
please share your view?Unless you have a specific situation, such as coordinating stats gathering with batch ETL processes, creating your own manual stats gathering scripts (which you will soon want to schedule/automate) is spending your time and money to rebuild functionality that you already paid for as part of your Oracle license.