Showing posts with label Statistics. Show all posts
Showing posts with label Statistics. Show all posts

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.