Search SSWUG.ORG:



DATABASES

Care and Feeding of Statistical Views This is an off-site link.  Please review our Terms of Service for additional information.


(Ember Crooks) The whole point of statistical views is to improve the performance of SQL that joins tables. Or to help you collect statistics on expressions – though if you’ve got 10.5, consider expression-based indexes for that instead. Giving the DB2 Optimizer more data is generally a good thing for query performance.

Read this article..







comments powered by Disqus