Tuesday, October 21, 2008

Effective Optimizer Statistics Update

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


Taken from www.basisconsultan.com.

No comments: