#DateForumTypeThreadPost
1719 Oct 2012 @ 03:38 PDTDatabaseReplyPlease tune this quey as it is taking terabytes spool spaceCheck in the step table (dbqlsteptbl) which step is creating huge spool file. There might be skew or some duplication might be happening.
1611 Oct 2012 @ 03:42 PDTDatabaseReplyWhat is index join confidenceEven I am trying to understand what the meaning of the term "index join confidence". It will be great if any of the Teradata Gurus can explain if this is good confidence level.  
1511 Oct 2012 @ 12:36 PDTDatabaseReplyRE: Stats collection and PerformanceThanks for the information!  
1409 Oct 2012 @ 03:54 PDTDatabaseReplyRE: Stats collection and PerformanceIn any scenario does collecting stats on the columns that are not required will degrade the performance of query. I understand that collecting stats itself is expensive as it will do FTS, but in an...
1309 Oct 2012 @ 03:52 PDTDatabaseReplySQL to find Row CountDieter, I have been doing the same way you mentioned. We are using  Informatica for data movement within teradata using pushdown optimization. There can be multiple insert/merge/update statem...
1209 Oct 2012 @ 03:19 PDTDatabaseReplyPrimary Index on VARCHAR columnWill there be any performance degradation when we join  CHAR to a VARCHAR column?
1104 Oct 2012 @ 01:53 PDTDatabaseTopicSQL to find Row CountHi,   I am trying to find if there is any way we can find the record count of queries that logged into DBQL with Insert or Update statement types. I tring to see the row count by taking the ...
1006 Sep 2012 @ 06:26 PDTDatabaseTopicRE: Stats collection and Performance Hi, I am having two questions related to collect stats. 1) I using Diagnostic HelpStats On For Session to know the recommended stats. Even after collecting the stats on that column, it&#...
917 Apr 2012 @ 12:51 PDTToolsTopicCopy tables between two different systems Hi,   We are planning to copy some tables from an active teradata database to another teradata database. We are planning to use datamover. But in addition to it we also wanted to tr...
820 Oct 2011 @ 04:37 PDTToolsReplyLoading a table with BTEQ script using csv file having numeric field with thousand seperator. Jimm - Thanks for the clarification.
720 Oct 2011 @ 11:05 PDTToolsReplyLast character of the file is not laoding into a table while using bteq script Thanks Suzzanne
620 Oct 2011 @ 10:48 PDTToolsReplyLoading a table with BTEQ script using csv file having numeric field with thousand seperator. Jimm, thank you for your reply. I understand that we can solve this issue by saving the file in different format. But I am just curious to know if it is possible in the BTEQ script (using &#...
519 Oct 2011 @ 09:43 PDTToolsReplyLoading a table with BTEQ script using csv file having numeric field with thousand seperator. How to load data which is in csv file format into a table using a BTEQ script; Data file has a numeric field with values having thousand seperator?
419 Oct 2011 @ 04:57 PDTToolsReplyLast character of the file is not laoding into a table while using bteq script I tried loading the table omitting SUBSTR function, but still I have the issue. If I just hit a enter at the end of last record and save the file, its loading the complete value. And also, I...
319 Oct 2011 @ 02:34 PDTToolsReplyLast character of the file is not laoding into a table while using bteq script I am using Version is 13.10.01.08. Bteq Script: DATABASE ABC; .IF ERRORCODE <> 0 THEN .GOTO LABEL_ERROR ;   .IMPORT VARTEXT ',' FILE=/xfer/BMD/extracts/For...
219 Oct 2011 @ 02:07 PDTToolsTopicLoading a table with BTEQ script using csv file having numeric field with thousand seperator. I am using a csv file (Saving a excel file in csv format) to load a table. I have numeric field with thousand seperator. When I am opening the csv file, the numeric field is showing up...
119 Oct 2011 @ 11:30 PDTToolsTopicLast character of the file is not laoding into a table while using bteq script Hi, I am using a BTEQ script to load a table. While loading, last character of the text file is missing. For example, in the text file, last column value of a last row is "Deadline 3&qu...