|12||29 Jul 2014 @ 09:46 PDT||carrie's blog||Tips on using Sampled Stats||Hi Carrie
Thanks for your reply. I will follow your suggestions and try to explore more. I may get back to you, in case guidance is required. :-)
|11||22 Jul 2014 @ 10:42 PDT||carrie's blog||Tips on using Sampled Stats||Hi Carrie
Thanks for you reply. Sorry for my late response. Your explanation is really helpful.
However, I have another question. For example, I have collected sample stat on a table and now goin... |
|10||11 Jul 2014 @ 10:18 PDT||carrie's blog||Tips on using Sampled Stats||Hi Carrie
Your blog is really helpful. I have a question, does sample stats work with aggregate functions as well? If not then full stat coll. will be required? Also if a table has almost 5m dat... |
|9||31 Mar 2014 @ 03:19 PDT||carrie's blog||Recommended Dictionary Statistics to Collect in Teradata 14.0||Thanks Carrie for your reply.
|8||18 Mar 2014 @ 01:46 PDT||carrie's blog||Recommended Dictionary Statistics to Collect in Teradata 14.0||Hi Carrie
Sorry, it's my bad. Actually in the discussion part Smarak mentioned something as DBC tables are all point in time tables and data are moved to PDCR tables. There was even a discussi... |
|7||15 Mar 2014 @ 10:16 PDT||carrie's blog||Recommended Dictionary Statistics to Collect in Teradata 14.0||Hi Carrie
When it says "The DBC tables are usually point in time tables", what does it mean ? Can you please give some examples of such dbc tables ?
|6||09 Jan 2014 @ 01:18 PST||Extensibility||Selecting an ALC compression algorithm||
Thanks for your update. I will surely raise a ticket with Teradata support. Before that I want a clear picture on what is happening. Because I am getting some unexpecte... |
|5||08 Jan 2014 @ 02:53 PST||Extensibility||Selecting an ALC compression algorithm||
Please correct my understanding.
ALC of TransUnicodeToUTF8 is used only for 7-bit US-ASCII (or ASCII) character set.
Where as LATIN is 8-... |
|4||31 Dec 2013 @ 11:55 PST||Marcio Moura||Let's talk about Multilevel Partitioned Primary Indexes (MLPPI)||
As Marcio has mentioned above
"This means that it is better to define the partitioning expressions on a MLPPI table by descending order based on the tot... |
|3||30 Dec 2013 @ 10:32 PST||Database||Skew-Sensitivity in the Optimizer: New in Teradata 12||Thanks Carrie for your reply.
Actually I tried testing from my end and got a specific result. I have already posted my observation in this forum.
|2||26 Dec 2013 @ 06:05 PST||Database||Skew-Sensitivity in the Optimizer: New in Teradata 12||Hi Carrie,
Here at one point you have mentioned,
"Instead of assuming each AMP will receive 1.1 millions rows during row redistribution, the Teradata 12 optimizer assu... |
|1||26 Sep 2013 @ 07:51 PDT||Database||Expanded Teradata Express Family Available||Is Teradata Express 13 for Windows still available or it has been obsolete?
I am unable to find it anywhere.