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