No, of course not. Personally I never estimate statistics, I always
compute, but Oracle recommends 20 percent, not 0.5
A histogram with a bucket size of 1 is ridiculous, as the default is 2
Degree is 8 is only useful if you have that many cpu's.
Gather stale means you should have set up monitor (alter table ...
monitor) and it will analyze the tables with expired statistics *only*.
You should leave that option out for the time being.
My default method_opt is 'for all indexed columns size 200'. Note if
Oracle doesn't need 200 buckets, you won't get 200 buckets!
--
Sybrand Bakker
Senior Oracle DBA
Received on Mon Jul 25 2005 - 10:01:53 CDT
