#DateForumTypeThreadPost
2111 Feb 2015 @ 09:09 PSTDatabaseReplyHelp Stats Displays Incorrect StatisticsIf you are worried about too much skipping leading to stale histograms and bad plans, it is easy to force recollections.  Just add a USING THRESHOLD clause on your COLLECT STATISTICS...
2004 Feb 2015 @ 09:45 PSTDatabaseReplyHelp Stats Displays Incorrect StatisticsStephen,   You can do an EXPLAIN COLLECT STATISTICS statement on the stats that did not change when you thought they should, and the explain text will indicate whether or not stats were...
1903 Feb 2015 @ 03:28 PSTDatabaseReplyInconsistent CPU: ResUsageScpu vs ResUsageSpsIf you saying that the ResUsageSPS table is reporting less CPU than the ResUsageSPMA table, this is expected behavior.   SPS only reports CPU used by the database.  SPMA catches everyth...
1808 Jan 2015 @ 12:55 PSTViewpointReplyTASM Exception and TASM FiltersUsmans,   In 15.10, you will have two new TASM options when you add a new exception to a workload in Workload Designer and the exception criteria is Elapsed Time.  The first option is t...
1705 Dec 2014 @ 10:44 PSTPrivate Forum
1602 Apr 2014 @ 09:59 PDTDatabaseReplyUpgrade TD14.10 and Reserved WordsThere should not be too many new reserved words.  In general, developers try to avoid adding new reserved words, especially ones that might cause a conflict.     Are you perha...
1508 Nov 2013 @ 12:40 PSTPrivate Forum
1412 Nov 2012 @ 02:58 PSTPrivate Forum
1312 Nov 2012 @ 02:43 PSTPrivate Forum
1212 Nov 2012 @ 09:11 PSTPrivate Forum
1104 Oct 2012 @ 02:51 PDTViewpointReplyViewpoint / Workload Monitor Dynamic Pipes View.This question was also posted on my blog on Dev X.  Here is the response I gave at that location: A query is not allocated to a resource partition directly. It is mapped to a performance grou...
1015 Aug 2012 @ 09:12 PDTPrivate Forum
926 Jun 2012 @ 09:59 PDTPrivate Forum
823 May 2012 @ 12:47 PDTPrivate Forum
711 Apr 2012 @ 12:52 PDTPrivate Forum
616 Feb 2012 @ 10:26 PSTPrivate Forum
521 Dec 2011 @ 01:31 PSTPrivate Forum
420 Dec 2011 @ 03:54 PSTPrivate Forum
325 Nov 2011 @ 01:38 PSTPrivate Forum
217 Sep 2010 @ 09:58 PDTDatabaseReplyPerformance comparsion MERGE INTO vs classic UPSERTMerge-into uses a new step called Merge Row Multiple Operations (MRM) that can do both updates and inserts in 1 step. It uses optimizations similar to those used by MultiLoad to replace an entire ...
128 Apr 2008 @ 04:36 PDTUDAReplyCollect Stats differenceThere is a small difference in how the statistics collection process will read the data, depending on whether the column is indexed or not. If there is a NUSI defined on the column, the statist...