Posted 19 Oct 2012
When you start designing a statistics collection process topics include:
Both problems involve some kind of prioritization process, which finally leads to a sorted list of COLLECT STATS statement (See Marcio Moura's blog When is the right time to refresh statistics?) Processing this list (using a BTEQ script or a cursor in a Stored Procedure) could lead to another problem: |
Thanks Dieter!
|