Updating statistics in oracle Bangalore sex voice
a sql code to remove all the special characters from a particular column of a table example :i NPUT-ABC -D. FOUTPUT ABC DEFAND IF THERE IS TWO NAMES LIKE ABC PRIVATE LTDONE SPACE SHOULD BE MAINTAINED BETWEEN 2 WORDS.... Hi Tom, I'm sorry, I am working on so much topics, that I don't have time to search.
The optimizer program uses statistics on tables and on the indexes surrounding those tables, so it's important to have statistics on both.
The dbms_stats utility does a far better job in estimating statistics, especially for large partitioned tables, and the better stats result in faster SQL execution plans.
Here is a sample execution of dbms_stats with the options clause.
In the next section, we will show you how to generate statistics on tables and indexes in your database.
Starting with the introduction of the dbms_stats package, Oracle provides a simple way for the Oracle professional to collect statistics for the CBO.
The choice of executions plans made by the Oracle SQL optimizer is only as good as the Oracle statistics.