#DateWhereItemComment
1229 Jul 2014 @ 09:46 PDTcarrie's blogTips on using Sampled StatsHi 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. :-) Thanks Santanu
1122 Jul 2014 @ 10:42 PDTcarrie's blogTips on using Sampled StatsHi 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...
1011 Jul 2014 @ 10:18 PDTcarrie's blogTips on using Sampled StatsHi 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...
931 Mar 2014 @ 03:19 PDTcarrie's blogRecommended Dictionary Statistics to Collect in Teradata 14.0Thanks Carrie for your reply. Thanking You Santanu
818 Mar 2014 @ 01:46 PDTcarrie's blogRecommended Dictionary Statistics to Collect in Teradata 14.0Hi 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...
715 Mar 2014 @ 10:16 PDTcarrie's blogRecommended Dictionary Statistics to Collect in Teradata 14.0Hi 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 ?   Thanking You Santanu
609 Jan 2014 @ 01:18 PSTExtensibilitySelecting an ALC compression algorithm Hi Guilian   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...
508 Jan 2014 @ 02:53 PSTExtensibilitySelecting an ALC compression algorithm Hi Guilian   Please correct my understanding.    ALC of TransUnicodeToUTF8 is used only for 7-bit US-ASCII (or ASCII) character set.  Where as LATIN is 8-...
431 Dec 2013 @ 11:55 PSTMarcio MouraLet's talk about Multilevel Partitioned Primary Indexes (MLPPI) Hi All   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...
330 Dec 2013 @ 10:32 PSTDatabaseSkew-Sensitivity in the Optimizer: New in Teradata 12Thanks 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. http://forums.teradata.com/forum/database/query-o...
226 Dec 2013 @ 06:05 PSTDatabaseSkew-Sensitivity in the Optimizer: New in Teradata 12Hi 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...
126 Sep 2013 @ 07:51 PDTDatabaseExpanded Teradata Express Family AvailableIs Teradata Express 13 for Windows still available or it has been obsolete? I am unable to find it anywhere.