Refresh the statistics of the table.
Dear all,
I got one call,they told me that plz tell me command to refresh the statistics of the table.i didn't understood what this means.
i told give some time i will tell you.
why this refresh is needed.what i should do if i want to refresh the statistics of the table.
why DBMS_STATS is used. in one website i saw this sentence
"DBMS_STATS is a PL/SQL package that generates and manages statistics for cost-based optimization. Use this package to gather, modify, view, statistics on indexes, tables, columns, and partitions."
now can anyone give me the exact scenario why and at what time this is used.plz tell me what i should do to refresh the statistics of the table. can i refresh the table also.
what is difference b/w refreshing the statistics of the table and refreshing the table.
regards,
veeresh.s