Home DATABASES ORACLE Effective Optimizer Statistics Update

Effective Optimizer Statistics Update

E-mail Print PDF
User Rating: / 0
PoorBest 

Following command is very effective, as its not estimating, doing a real calculation on tables including all indices to find the right path for R3 Systems.

brconnect -u / -c -f stats -t all -m +I -s P10 -f allsel,collect,method,precision -p 8

 

Comments (0)add comment

Write comment
smaller | bigger

security image
Write the displayed characters


busy
 

Our valuable member Huseyin Bilgen has been with us since Saturday, 06 May 2006.