35 | 10 Jan 2015 @ 02:34 PST | carrie's blog | Statistics collection recommendations – Teradata 14.0 | Adding 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... |
34 | 10 Jan 2015 @ 12:43 PST | carrie's blog | Statistics collection recommendations – Teradata 14.0 | I 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 ... |
33 | 10 Jan 2015 @ 12:15 PST | carrie's blog | Statistics collection recommendations – Teradata 14.0 | Hi,
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)
... |
32 | 24 Sep 2014 @ 06:41 PDT | carrie's blog | Using the ResUsageSAWT table to Monitor AMP Worker Tasks | Thank you very much Carrie. Got clarified now.
|
31 | 21 Sep 2014 @ 01:54 PDT | carrie's blog | Using the ResUsageSAWT table to Monitor AMP Worker Tasks | Hi 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 ... |
30 | 02 Apr 2014 @ 09:06 PDT | carrie's blog | New opportunities for statistics collection in Teradata 14.0 | Thank you very much carrie....
|
29 | 19 Mar 2014 @ 11:49 PDT | carrie's blog | New opportunities for statistics collection in Teradata 14.0 | Hi 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 ... |
28 | 14 Dec 2013 @ 04:05 PST | Teradata Performance Considerations | Memory 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... |
27 | 21 Nov 2013 @ 10:32 PST | carrie's blog | Automatic Throttles in Teradata 14.0 and 14.10 | Thank you very much for your Response.
Thanks,
Vasudev
|
26 | 18 Nov 2013 @ 10:28 PST | carrie's blog | Automatic Throttles in Teradata 14.0 and 14.10 | Hi 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... |
25 | 14 Nov 2013 @ 09:04 PST | Database | Skew-Sensitivity in the Optimizer: New in Teradata 12 | Hi Carrie,
Thank you very much for your response.
Will post the questions in the particular forum post.
Again, thanks for your response.
|
24 | 10 Nov 2013 @ 02:14 PST | Database | Skew-Sensitivity in the Optimizer: New in Teradata 12 | Hi 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... |
23 | 08 Nov 2013 @ 10:22 PST | carrie's blog | Utility 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... |
22 | 01 Nov 2013 @ 08:05 PDT | carrie's blog | Using the ResUsageSAWT table to Monitor AMP Worker Tasks | Thank you very MUch Carrie. Got Clarified now.....
|
21 | 30 Oct 2013 @ 11:07 PDT | carrie's blog | Using the ResUsageSAWT table to Monitor AMP Worker Tasks | Hi 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... |
20 | 31 Jul 2013 @ 10:35 PDT | Database | Indexes, 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.
|
19 | 22 Jul 2013 @ 11:21 PDT | carrie's blog | Statistics collection recommendations – Teradata 14.0 | Thank you very much. Got clarified now !!!
|
18 | 22 Jul 2013 @ 11:20 PDT | carrie's blog | Crossing NUSI Update Contention Off Your Watch List | Hi 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.
|
17 | 19 Jul 2013 @ 11:45 PDT | carrie's blog | Statistics collection recommendations – Teradata 14.0 | Hi 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... |
16 | 16 Jul 2013 @ 11:49 PDT | carrie's blog | Statistics collection recommendations – Teradata 14.0 | Hi 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... |
15 | 17 Apr 2013 @ 10:05 PDT | carrie's blog | Statistics collection recommendations – Teradata 14.0 | Hi Carrie,
Thank you very Much, got clarified now.
|
14 | 14 Apr 2013 @ 10:54 PDT | carrie's blog | How to Calculate Your Max Number of Usable AMP Worker Tasks | Hi 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... |
13 | 13 Apr 2013 @ 07:42 PDT | carrie's blog | Statistics 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 ... |
12 | 10 Apr 2013 @ 10:28 PDT | carrie's blog | Statistics collection recommendations – Teradata 14.0 | Hi 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... |
11 | 10 Apr 2013 @ 10:10 PDT | carrie's blog | Eliminating Unplanned Delays Within Load Utility Jobs | Hi 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 ... |