Search SSWUG.ORG:



DATABASES

How to upgrade Dynamic Sampling on a Query already using an imported SQL Profile This is an off-site link.  Please review our Terms of Service for additional information.




(Carlos Sierra) I have this query that references a couple of Global Temporary Tables (GTT). These GTT have no CBO Statistics, thus Dynamic Sampling (DS) is used on them. The problem is default value of 2 at the instance level samples only 64 blocks and these GTT are large.

Read this article...







comments powered by Disqus