#DateWhereItemComment
1005 Apr 2013 @ 10:49 PDTDatabaseTo Peek or Not to Peek, That is the QuestionThanks for your response Carrie, Whether the Cache flag has anything to do with query optimization? Say, if it is empty then the query has to be optimized? Please advise.
930 Mar 2013 @ 11:58 PDTDatabaseTo Peek or Not to Peek, That is the QuestionHi Carrie, In the first two entries, cache flag is empty. Whether this means that these queries needs to be  reviewed to determine additional optimization? Please advise. Thanks in advance.
820 Mar 2013 @ 11:05 PDTcarrie's blogUtility Throttles – You Won’t Regret It!Hi Carrie, I am using TD12 and queries are taking longer to run than normal. Which teradata tool can be used to identify the no of active throttles?  From some blog i came to know using TDWM...
702 Feb 2013 @ 12:03 PSTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Thank you very much Carrie. Got clarified now.
601 Feb 2013 @ 01:23 PSTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Hi Carrie, I am using Teradata 12. I created a table with single column NUSI and collected stats on the index. Then i dropped the index. Still i able to see the stats using help stats and in dbc...
522 Jan 2013 @ 03:39 PSTcarrie's blogCPU Limits at Multiple LevelsFine Carrie, thank you very much. -Ganapathy
421 Jan 2013 @ 05:32 PSTcarrie's blogHow to Calculate Your Max Number of Usable AMP Worker TasksHi Carrie, Thank you very much for such a nice blog on AWT. So in short AWT's are 1. They are limited to 62(active) per AMP. 2.They can be reserved for special use. 3. Additional AWTs are cre...
317 Jan 2013 @ 04:52 PSTcarrie's blogCPU Limits at Multiple LevelsThank you very much Carrie, Learned new information from your reply. I want to know is there any specifications like average system CPU use of X% or parser usage at X% or Number of AWT's or some...
212 Jan 2013 @ 09:42 PSTcarrie's blogCPU Limits at Multiple LevelsHi Carrie, Is there any critical resource levels for Tactical queries? While going through one of the articles i came across with the tactical queries. So, i want to know is there any resource...
131 Dec 2012 @ 04:18 PSTcarrie's blogSimplifying AMP Worker Task Monitoring and Getting it RightHi Carrie, I want to know the general usage of DBC.ResUsageSAWT table. When i saw the column details, it contains lot many columns. Is there any way we can indentify whether the the user is out...

Pages