Hello,
I could not find any recommandations for the level of set statistics and what a specific level does actually mean. What is the difference between 1, 50 and 100? What is recommanded for a table or column?
Default I believe is 10. The higher the number, the more statistics are kept, with a maximum of 1000.
The default is a little bit low for columns used in foreign keys, though frequently it is okay. When problems start, try setting them to 100 or 200. Higher is more accurate, but takes longer to compute, *and* takes longer when planning the optimal query method. It can be worth it, though.
John =:->
signature.asc
Description: OpenPGP digital signature
