#DateForumTypeThreadPost
2414 Aug 2015 @ 06:28 PDTDatabaseTopicCPU Secs for a stored ProcedureIs there anyway to calculate the CPU secs used by a stored procedure and all its internal SQL. I want the facebook functionality to tag Dieter :-) Thanks Folks    
2312 May 2015 @ 03:35 PDTDatabaseTopicJOIN ACCESS ROWSHow is the value for Join Acess Rows Calculated ? I have attached the link to the teradata example here but cannot work out how they get to the value of 1,400,000. http://www.info.teradata.com/HT...
2204 May 2015 @ 03:34 PDTDatabaseReplyMERGE INTO and trigger firingI have after some investigation found that infact the teradata documentation is incorrect when reffering to before triggers as before triggers essentially are not supported in Teradata. Also depend...
2130 Apr 2015 @ 01:41 PDTDatabaseReplyMERGE INTO and trigger firingIn the documentation before triggers are reference however when I try create a before trigger I am told before triggers are not supported. How does that work ?
2030 Apr 2015 @ 12:50 PDTDatabaseTopicMERGE INTO and trigger firingIt is said that the placement of the INSERT before or after the UPDATE statement affects the order in which triggers fire.  If MERGE WHEN MATCHED is specified first then before trigge...
1920 Apr 2015 @ 05:17 PDTDatabaseTopicEXPLAIN - Tag Sort …by way of the sort key in spool field1… Field1 is created to allow a tag sort. This is in the Teradata documentation ref...
1802 Mar 2015 @ 11:57 PSTDatabaseReplyCOLLECT STATS TD V14.10I see there is a question posted in that feed : Will existing table level collect stats statements utilize multiple stats in one scan when possible? Carrie Answered : 1. First, you have to re...
1702 Mar 2015 @ 05:12 PSTDatabaseTopicCOLLECT STATS TD V14.10Consider the following. I create an employee_table and then create and execute individual collect stats commands as follows COLLECT STATISTICS on Employee_Table COLUMN Employee_No ; COLLEC...
1602 Mar 2015 @ 04:32 PSTDatabaseReplyALTER TO CURRENTThanks Dieter !
1512 Jan 2015 @ 10:26 PSTDatabaseReplyFind Second Highest Salary - SQLQUALIFY ROW_NUMBER() OVER (PARTITION BY DEPT ORDER BY SAL DESC) = 2  
1412 Jan 2015 @ 10:18 PSTDatabaseReplyALTER TO CURRENTSorry for the question not being clear. I would essentially like to know why adding intervals to our current_date allows the query plan to stay the same. Not sure why it would change if we didnt ha...
1308 Jan 2015 @ 06:05 PSTDatabaseReplyAnalyzing Teradata SQL QueriesIf anyone is intrested I wrote something in C# and it worked okay. not 100% accurate but close in terms of what tables join most often what is most often used in where clause etc etc. Inbox me if y...
1208 Jan 2015 @ 05:53 PSTDatabaseTopicALTER TO CURRENTI need to understand what the issue is with time_zones and ALTER TO CURRENT and why the query plan changes if we dont add intervals. IE a translation into English would be good :-) This is from th...
1104 Dec 2014 @ 02:41 PSTDatabaseReplyIndex selectionMany thanks Todd !
1004 Dec 2014 @ 12:21 PSTGeneralReplyPartitioningThanks Dieter your explanation has cleared it up for me. Knowing the combined partitioning expression is the partition Number makes everythng else I read now clear. Many Thanks    
925 Nov 2014 @ 04:50 PSTDatabaseReplyrowkeyDepends on how many partitions you have. it you have less then 65535 then your rowkey is going to be  2 bytes + 4bytes for the Row Hash +  4 bytes for the uniqueness value More then 655...
825 Nov 2014 @ 03:37 PSTGeneralTopicPartitioningI understand the PARTITION#Ln is used to denote a level in MLPPI. What is the combined partitioning Expression ? Is this all the ranges specified in a MLPPI table. ? How does the RowKey differ to...
706 Nov 2014 @ 10:22 PSTDatabaseReplyIndex selectionYes it does but the Teradata documentation states many more reasons and I would like additional information on there stated case which I have presented above. Anybody got any ideas ? I was thinking...
629 Oct 2014 @ 04:57 PDTDatabaseTopicIndex selectionWe are told that Transaction factors affect index selection within Teradata. Could someone please expalin how the following affects index selection. •How are transactions written? •How ...
501 Apr 2014 @ 11:27 PDTDatabaseReplyAnalyzing Teradata SQL QueriesWe have thousands of queries we need to analyze to assess what tables are usually joined on. What columns are used in the where clause etc etc so doing this manually is not an option. The SQL ...
431 Mar 2014 @ 06:26 PDTDatabaseTopicAnalyzing Teradata SQL QueriesHi, I would like to analyze some of the SQL stored in the DBQLSqlTbl  table. We have one or two tables we would like to do analysis on(Lets call it TABLEA)so we would need to check thing...
319 Mar 2014 @ 11:57 PDTTeradata ApplicationsTopicTeradata Index Wizard Installation - ErrorHi, After filling in the required fields on the "Setup QCD" screen I have clicked create to be returned with an error. I have the create Database Permissions and create table permission...
217 Mar 2014 @ 05:33 PDTDatabaseReplyCalculate Performance Impact of Secondary IndexThank you very much for the feedback .
127 Feb 2014 @ 01:41 PSTDatabaseTopicCalculate Performance Impact of Secondary IndexIs there a way to calculate the performance impact of adding a secondary index to a table. Either Unique or NON Unique.