#DateWhereItemComment
3510 Jan 2015 @ 02:34 PSTcarrie's blogStatistics collection recommendations – Teradata 14.0Adding on to the above one i am intrested to understand about the order of columns used in multi column stats. In TD 12 whether it makes any difference. Say taking the same above mentioned scenario...
3410 Jan 2015 @ 12:43 PSTcarrie's blogStatistics collection recommendations – Teradata 14.0I got the answer for my question from Carrie's blog posted on 19-Sep-2012. Carrie, Please correct me if i am wrong. Column level stats is helpful even if the indexes are dropped still stats ...
3310 Jan 2015 @ 12:15 PSTcarrie's blogStatistics collection recommendations – Teradata 14.0Hi, Sorry for asking very basic question. But i wanted to know the difference.  I am having a table A like this Col1 int, Col2 int, col3 int, col4 int, col5 int PI(Col1) NUSI1(Col2) ...
3224 Sep 2014 @ 06:41 PDTcarrie's blogUsing the ResUsageSAWT table to Monitor AMP Worker TasksThank you very much  Carrie. Got clarified now.
3121 Sep 2014 @ 01:54 PDTcarrie's blogUsing the ResUsageSAWT table to Monitor AMP Worker TasksHi Carrie, We are using TD12. During morning time response time for the queires are missing the SLA's. We had noted that AMP's are flow controlled. We had reserved 2 AWT's per amp. If ...
3002 Apr 2014 @ 09:06 PDTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Thank you very much carrie....
2919 Mar 2014 @ 11:49 PDTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Hi Carrie, I am having some doubts regarding the automatic stats collection process. Currently i am working on Version 13.10 and we are doing the stats collection on big/important tables on daily ...
2814 Dec 2013 @ 04:05 PSTTeradata Performance ConsiderationsMemory on Linux Teradata Systems - How do I know if I have a problem?Hi, From the above blog post i infer that when we upgrade the system from MP-RAS to linux, then more memory is required for Linux system. Is there any other factors needs to be considered while u...
2721 Nov 2013 @ 10:32 PSTcarrie's blogAutomatic Throttles in Teradata 14.0 and 14.10Thank you very much for your Response. Thanks, Vasudev
2618 Nov 2013 @ 10:28 PSTcarrie's blogAutomatic Throttles in Teradata 14.0 and 14.10Hi Carrie, I am having a basic doubt. While considering the difference between filters and Throttles, Filters can be used only to restrict the queries at object level and resource level. But in th...
2514 Nov 2013 @ 09:04 PSTDatabaseSkew-Sensitivity in the Optimizer: New in Teradata 12Hi Carrie, Thank you very much for your response. Will post the questions in the particular forum post.  Again, thanks for your response.
2410 Nov 2013 @ 02:14 PSTDatabaseSkew-Sensitivity in the Optimizer: New in Teradata 12Hi Carrie, I am using TD12 and going to add 2 new columns in a big table of 200 million rows. Since having enough space, planning to execute it using insert select. Going to create a new table wit...
2308 Nov 2013 @ 10:22 PSTcarrie's blogUtility Session Management - It's Inside the Database in Teradata 13.10! (UPDATED)Hi, I am using TD 12. An application is firing 60 concurrent queries. Our SLA is 10 seconds for a query but its taking 20 secs to execute a query. If we increase the number of sessions for a quer...
2201 Nov 2013 @ 08:05 PDTcarrie's blogUsing the ResUsageSAWT table to Monitor AMP Worker TasksThank you very MUch Carrie. Got Clarified now.....
2130 Oct 2013 @ 11:07 PDTcarrie's blogUsing the ResUsageSAWT table to Monitor AMP Worker TasksHi Carrie, I am using TD 12, What is the significance of FlowControlled field in resusageawt table? I can see in Resource usage book, that if it is non-zero amp was flow controlled. I got the...
2031 Jul 2013 @ 10:35 PDTDatabaseIndexes, Too Much of a Good Thing?Hi,  I am using TD V12. By reducing the number of SI in target can the performance be improved. I am using TPUMP to load the data to target table? Please advise.
1922 Jul 2013 @ 11:21 PDTcarrie's blogStatistics collection recommendations – Teradata 14.0Thank you very much. Got clarified now !!!
1822 Jul 2013 @ 11:20 PDTcarrie's blogCrossing NUSI Update Contention Off Your Watch ListHi Carrie, I am using TD 12, I am having a table with many SI and its loaded using TPUMP. When the number of SI in the table is reduced, can this improve the performance of TPUMP. Please advise.
1719 Jul 2013 @ 11:45 PDTcarrie's blogStatistics collection recommendations – Teradata 14.0Hi Carrie, Sorry for making it complicated. My question is this. In TD 12 i want to store data on a table and for that table i need to take collect stats also. Out of spool,journal,derived and GTT...
1616 Jul 2013 @ 11:49 PDTcarrie's blogStatistics collection recommendations – Teradata 14.0Hi Carrie, In TD 12, is there any option to store data and collect stats on that data into a same table. Which type of table(Spool,journal,Dervied,GTT) can be used for this purpose? Please advise...
1517 Apr 2013 @ 10:05 PDTcarrie's blogStatistics collection recommendations – Teradata 14.0Hi Carrie, Thank you very Much, got clarified now.
1414 Apr 2013 @ 10:54 PDTcarrie's blogHow to Calculate Your Max Number of Usable AMP Worker TasksHi Carrie, Whether the performace of tactical queries can be improved by creating a reserve of AWT for workload defn or Isolate the queries in their own workload definition? Please advise &n...
1313 Apr 2013 @ 07:42 PDTcarrie's blogStatistics collection recommendations – Teradata 14.0  Hi Carrie, I am having two questions. Please clarify. Q1.In Teradata 12, is there any option to find no of rows and and avg row size for SI sub table. Which one can be used Collect ...
1210 Apr 2013 @ 10:28 PDTcarrie's blogStatistics collection recommendations – Teradata 14.0Hi Carrie, In Teradata 12, is there any option to find no of rows and and avg row size for SI sub table. While going through the SQL data defns statements document, collect demographics is mentio...
1110 Apr 2013 @ 10:10 PDTcarrie's blogEliminating Unplanned Delays Within Load Utility JobsHi Carrie, I am using teradata 12. Specifications are like this: Utility throttle for number of combined FastLoad and MultiLoad utilities to a maximum of 2 and delays utilities that exceed the ...

Pages