#DateForumTypeThreadPost
4114 Dec 2012 @ 01:27 PSTDatabaseReplyMerge Over UpdateMERGE and UPDATE perform two different tasks. UPDATE only updates existing rows. MERGE tests to see if the row exists, performs an INSERT if not and performs and UPDATE if the row exists. If only U...
4014 Dec 2012 @ 07:24 PSTPrivate Forum
3905 Dec 2012 @ 07:08 PSTDatabaseReplyUnion vs Group byIf you want to find the unique set of <tran_id,cust_id,acct_nbr> then use DISTINCT. SELECT DISTINCT tran_id,cust_id,acct_nbr FROM financial.checking_tran;
3805 Dec 2012 @ 07:02 PSTDatabaseReplySkewness in nopi TableHow did you load the data into the table? How many rows did you load into the table? How big is the system?
3705 Dec 2012 @ 06:50 PSTDatabaseReplyDo not insert a record into a table with a foreign key.Any time you get a 3610 error, it should be reported as a Teradata incident. It represents a fault in the database engine that should be identified and repaired.
3612 Nov 2012 @ 01:25 PSTPrivate Forum
3510 Nov 2012 @ 05:00 PSTPrivate Forum
3418 Aug 2012 @ 03:19 PDTGeneralReplyhow to Check in Explain Plan SI is used or norThis is not the step that would tell you. This says it is joining two spools which means it has already accessed and spooled both tables. The use of the index would come when it is accessing the ta...
3307 Aug 2012 @ 10:31 PDTPrivate Forum
3207 Aug 2012 @ 08:13 PDTAnalyticsReplyhashrow functionOn 13.10 that has been newly installed via Sysinit, there is a new hashing algorithm that changes the result from HashRow. The changes affect Unicode data the most but also affect the result from L...
3103 Jul 2012 @ 12:22 PDTDatabaseReplyneed helpThe teradata optimizer does not care if joins are specified in the where clause or in JOIN syntax in the FROM clause, or even a combination of the two. It will generate the same plan. The query as ...
3025 May 2012 @ 12:01 PDTDatabaseReplyNUSI SubtableA single table join index can have a PI different from the underlying table. You can refer back to the rows by using ROWIDS form or you can cover the columns that will be used in the common queries.
2925 May 2012 @ 11:50 PDTDatabaseReplyPrivelege issueRpad_2 is a reference to a UDF.
2825 May 2012 @ 11:16 PDTGeneralReplyTeradata Functions9 is the formatting character representing a numerical digit - stolen from COBOL oh so long ago.
2717 May 2012 @ 12:46 PDTDatabaseReplyFULL JOIN Not working as required please show the query you tried and the results of that query.
2617 May 2012 @ 12:28 PDTPrivate Forum
2517 May 2012 @ 12:04 PDTGeneralReplyAny idea on what "improperly formatted directed request" means in restore Job Failure? Please raise an incident with Teradata support.
2424 Apr 2012 @ 10:15 PDTDatabaseReplydiff between USI and NUSI It is possible to create an index that is hash distributed as you describe. Use a single table join index with a primary index of the fields you want it hash distributed on. You can have ROWIDs ...
2318 Apr 2012 @ 04:15 PDTDatabaseReplyreset identity column after table moveIt is possible to set DBSControl to 1 but then all inserts and loads will be single threaded though the id allocator and will severely affect the scalability and performance of inserts or loads of ...
2226 Jan 2012 @ 10:28 PSTPrivate Forum
2126 Jan 2012 @ 08:43 PSTDatabaseReplyCopy/Backup Teradata TablesSee Teradata Data Mover. Built to efficiently move data between Teradata systems. Recommended solution if you are doing a lot of this, many tables and repeatedly. TPT. It can be set up to expor...
2025 Jan 2012 @ 04:47 PSTDatabaseReplyROW LEVEL COMMITS IN TERADATANo - there is no conflict between real time and huge volumes. It is all a matter of capacity planning and service level planning as long as you have a fully scalable technology. Call detail at 10 m...
1925 Jan 2012 @ 04:43 PSTDatabaseReplyROW LEVEL COMMITS IN TERADATAThere are a couple comments above about "momentary inconsistencies". These are not correct for normal updates of a rowin place - the normal cases of update or upset setting a new value for afild in...
1823 Jan 2012 @ 06:52 PSTDatabaseReplyAmount of data read from disk Start with the ResLdvByNode macro. "host" refers to network traffic in and out of the Teradata platform. "net" refers to BYnet traffic. "ldv" refers to ...
1720 Jan 2012 @ 08:47 PSTGeneralReplydirty read record When an insert is performed to a table on Teradata, the row(s) is inserted directly into its position in the table. There is no separate place where rows are stored while being inserted. Some pr...

Pages