#DateForumTypeThreadPost
905 May 2014 @ 05:18 PDTData ModelingReplyUsing a PPI column in PISo table B is second in the join path.  If the joins to Table B do not already include the new index column then there will definitely be an impact - Table B will need to undergo a full t...
812 Nov 2013 @ 01:01 PSTData ModelingReplyCan Teradata display the Quarter value of a date?Which did you run, against SYS_CALENDAR or the math above?  I believe the math above should be division by 3 and not 4.   SELECT DATE, ((CAST(EXTRACT(MONTH FROM DATE) AS BYTEINT)-1)/3)+...
705 Nov 2013 @ 04:09 PSTData ModelingReplyPPI table having a column for same PI and SI Good to know, Dieter.  For some reason when I tried that scenario on my version of Teradata Express 13.1 it would not allow me to build the duplicate secondary (I always like to fact check bef...
604 Nov 2013 @ 10:40 PSTData ModelingReplyPPI table having a column for same PI and SI What I still do not understand is are you asking about implementing identical NUPI and USI indexes, or using the NUPI column(s) in a USI with additional columns?    Let me create an exa...
504 Nov 2013 @ 06:21 PSTData ModelingReplyPPI table having a column for same PI and SI I'm assuming the purpose of the USI is simply to enforce the PK, otherwise I can think of no other reason to include the PI in a secondary index as the optimizer should always choose to utilize...
407 Oct 2013 @ 07:39 PDTData ModelingReplyRow header Raja, are you asking if there are times when the use of MVC can produce a table space that is actually larger than the table without compression?  If so, the answer is "yes".  I...
307 Oct 2013 @ 07:33 PDTData ModelingReplyAvailability of Telecom Communication Data model documentation for RFP preparationRitabrata, There are varying levels of documentation for the CLDM depending on your needs, from sales presentations that are available to employees on the SharePoint, to mode detailed and IP prote...
220 Sep 2013 @ 06:32 PDTData ModelingReplyDo we need an intelligent key for each subject areaAn "intelligent key", as I understand it, serves as a unique identifier, but also contains within itself information that can be parsed out.  For example, if a company has account nu...
120 Sep 2013 @ 05:58 PDTData ModelingReplyModeling for NUPI and USI combinationWhen choosing your PI, as Dieter has stated, your primary goal is to optimize access moving forward, keeping in mind both its role in data distribution across the platform and how it may impact loa...