#DateForumTypeThreadPost
26611 May 2016 @ 02:31 PDTGeneralReplyHASHAMP function and column valuesSee the documentation under create table, it will tell you all about the syntax for NO PRIMARY INDEX (NOPI).   With NOPI, column data is not used for distribution, it is a round robin/random...
26509 May 2016 @ 10:18 PDTDatabaseReplyMULTILOAD and NUSIThe NUSI index entries are local to the same AMP as the base table row. Other indexes do not have this property.
26406 May 2016 @ 07:28 PDTDatabaseReplyBad data in table , need suggestion to isolate the problemLike the previous post, I wonder what data type the timestamps are stored in.    if there is any kind of naming convention(s) that allows selection of the column names which contain the...
26306 May 2016 @ 07:20 PDTGeneralReplyHASHAMP function and column valuesSQL does not allow for the substitution of column names in an expression. Given the table with column names, a SQL can be written with string concatenation a which results in one SQL statement per ...
26205 May 2016 @ 05:56 PDTDatabaseReplyEXECUTE PROCEDURE access It sounds like the role was not activated. "SET ROLE R_DBA;"
26104 May 2016 @ 05:28 PDTDatabaseReplyCAST VarcharCAST is an ANSI construct. What error are you getting from the tool? Have you talked to WebFocus about the error?
26003 May 2016 @ 11:54 PDTUDAReplyTeradata DSA online backupNo spool is used during DSA backups. The tables are not spooled, they are copied directly out to the backup environment. The changes are stored in a subtable as part of the permanent table until su...
25903 May 2016 @ 09:11 PDTDatabaseReplyCommon Table Expressions (CTE) No compilation necessary in either case. It is just part of the SQL SELECT statement and is all parsed/optimized together. The second form in not like a virtual table, it is very specific to defini...
25802 May 2016 @ 06:49 PDTDatabaseReplyAvoid skewing during delete TeradataIt would help if the whole Explain plan was available. The step above is spooling the tbl1 copy of the table and qualifying on the date range. There is no qualification on "tbl1.non-PI is not ...
25730 Apr 2016 @ 04:18 PDTDatabaseReplyCommon Table Expressions (CTE) There are two forms of CTE. The first is an alternate syntax for specifying SQL select statements prior to the query which will use them. Many people and many SQL generation tools find this an easi...
25630 Apr 2016 @ 03:59 PDTDatabaseReplyDiff between CTE and Volatile tables in TeradataOne advantage of the CTE is that the optimizer sees it as part of the query just as if it was specified in the FROM clause or if the query was packaged in a view and then referenced in the FROM. Th...
25529 Apr 2016 @ 07:00 PDTGeneralReplyLimit query to process fewer recordsReplace "From        P_EDW_DIST_VIEW.PHRM_CLM_ALL_TRANS_FACT a " with "From (SELECT TOP 100 * FROM P_EDW_DIST_VIEW.PHRM_CLM_ALL_TRANS_FACT) a...
25422 Apr 2016 @ 01:54 PDTDatabaseReplyLEFT JOINs and order of positions of fields in ON conditionThe order of the expressions in an equality makes no difference of any kind. It definately does not turn this query into an inner join. The two queries above are identical from the point of view of...
25321 Apr 2016 @ 08:10 PDTDatabaseReplyTerradata : Terradata not taking table-name for query.As specified the expression says: select <the result of concatenating the contents of column smallname with a blank with the contents of column bigname>. It does not say: select <from a...
25220 Apr 2016 @ 05:06 PDTDatabaseReplyImpact CPU on Statistics StatementsIf you are on TD14.10 or higher, use AutoStats. See Carrie Ballinger's documents on this site to get started.   It will not be possible to change the impact CPU use for a full stats coll...
25118 Apr 2016 @ 11:08 PDTGeneralReplySet tenacity and sleep in Tearadata JDBCOr better yet, get the DBA/admin folks for your system to enable utility throttles in the database.
25014 Apr 2016 @ 11:21 PDTDatabaseReplyEXPLAINBecause workload is so widely variable an Explain that varied the estimates based on workload at the time of the explain would be widely varying and not comparable at all from one plan to the next ...
24914 Apr 2016 @ 09:20 PDTGeneralReplyTeradata SQL error 3706As the manual shows ... It goes after the closing paren for the select before the final ";".
24813 Apr 2016 @ 04:04 PDTGeneralReplyTeradata SQL error 3706WITH [NO] DATA is required on a CT AS.
24713 Apr 2016 @ 10:31 PDTDatabaseReplyRewrite Case when statementsThe case expressions are the same in the 1,3,5 lines and the 2,4,6 lines. Is this intended? If the desire is to just have a shorthand for the repetition, then the name specified in the AS can just ...
24612 Apr 2016 @ 10:58 PDTDatabaseReplyAvoid skewing during delete Teradatathe condition above says "and tbl1.PI is not null" rather than "tbl1.non-PI is not null"
24508 Apr 2016 @ 10:31 PDTDatabaseReplyWill increasing block size help handle the error : The maximum possible Row length in the table is too largeA review of data types may be in order as well. If there are a lot of char/varchar columns, review the lengths to see if the lengths defined are really required for instance.
24406 Apr 2016 @ 01:22 PDTDatabaseReplyJoining varchar to integerYou can try to cast the integer to CHAR. But you have to know the format of A.Card_Id in order to cast the integer in a way which will compare properly. It sounds as if A.Card_Id has some values th...
24306 Apr 2016 @ 08:57 PDTDatabaseReplyFiltering on dates - Explain plan looks right but it returns 0 rows. If "(a.date_ck between '20160301' and '20160331')" works as written and date_chk is integer, then the dates are not Teradata date storage and the 1160331 form will not com...
24206 Apr 2016 @ 06:57 PDTDatabaseReplyFiltering on dates - Explain plan looks right but it returns 0 rows. What data type is date_chk?

Pages