#DateWhereItemComment
928 Jul 2015 @ 09:30 PDTDatabaseIdentifying Used, Unused and Missing StatisticsChandra, THRESHOLD option is designed to skip stats collection when not required. Without this option, stats would be collected all the time. So, not sure why enabling THREHSOLD causes your st...
829 Apr 2015 @ 11:48 PDTDatabaseIdentifying Used, Unused and Missing StatisticsKaram, The purpose of access logging and how it compares with DBQL logging is nicely described in this following comment. https://forums.teradata.com/forum/database/access-logging-and-query-loggin...
723 Apr 2015 @ 10:44 PDTDatabaseIdentifying Used, Unused and Missing StatisticsDBQLObjTBl logs the object usage at query level whereas USECOUNT option logs usage globally (for all queries going against the object). The other difference is that DBQLObjTbl doesn't log stats...
630 Mar 2015 @ 05:55 PDTDatabaseIdentifying Used, Unused and Missing StatisticsRajath, Both user and system OUC counts are identical, with the only difference being the ability to reset user‑level use counts by users and system‑level use counts only by Teradata Database. ...
530 Mar 2015 @ 05:50 PDTDatabaseIdentifying Used, Unused and Missing StatisticsSravan, The OUC issue with load utilites is fixed in 14.10.4.12 e-fix release. As per the TD knowledge article KAP316902A, the workaround is to disable OUC for the target databases of mload and flo...
426 Mar 2015 @ 09:52 PDTDatabaseIdentifying Used, Unused and Missing StatisticsKishire, It is not required to disable and re-enable usecounts for backups.
326 Mar 2015 @ 09:51 PDTDatabaseIdentifying Used, Unused and Missing StatisticsRaja, Since you are creating  a new table, it is not possible to trasfer the OUC from the old table. Also, if you are collecting stats on the new table afresh, it is not required to preserve t...
212 Mar 2015 @ 11:33 PDTDatabaseIdentifying Used, Unused and Missing StatisticsUsageType is marked as "STA" for statics usage entries. Other entries are marked as "DML". Please refer to the following user manual which explains how the entries are logged. ...
111 Mar 2015 @ 09:07 PDTDatabaseIdentifying Used, Unused and Missing StatisticsSamir, All DBQL options including USECOUNT can be enabled only at database level as of now. For each table the max number of entreis would be number of columns +number of indexes + number of stats ...