#DateForumTypeThreadPost
2810 Jul 2015 @ 06:35 PDTDatabaseReplyUDFHiding external c code in a UDF: I need to be able to hide the external c code for my function for security reasons but am unable to find instructions on how to do this. We do not want anyone...
2709 Jan 2014 @ 06:29 PSTPrivate Forum
2605 Sep 2013 @ 05:02 PDTToolsReplyRegarding Temporary SpaceIf you allocate 10GB of perm space to the user that means they can use up to 10 GB of space for storing data on your system . Spool is different, it does not pre-allocate space for the user. It is...
2521 Aug 2013 @ 07:39 PDTDatabaseReplyCollect StatisticsYou need to show the ddl of the tables, the stats that are collected and the explain from the query to help determine why it is performing slowly. --Shelley--
2420 Aug 2013 @ 05:44 PDTToolsReplyMload error - 2794 - UPI is an identity columnYou have defined the identity column with cycle so that will eventually allow a duplicate value.  Also the identity column in the table does not necessarily  increase by one each time a ...
2314 Aug 2013 @ 10:43 PDTDatabaseReplyTPUMP pack parameter "PACK <statements>" in TPUMP  are used  to specify the number of data records to be packed into one request, PACK is a TPump keyword and “statements” ac...
2206 Aug 2013 @ 05:12 PDTDatabaseReplyFor joins NUPI can be a better choice than a UPIAs ulrich says, you need the context because it really depends on your data and what you need to join on. For example if your joins are most often on columns that will have duplicates  then a...
2119 Jul 2013 @ 09:14 PDTGeneralReplyTuning the queryAlso the guideline for allowable  skew is dependent on the size of the table. Small tables  can have a larger % skew but that is not usually  a problem. For larger tables you...
2010 Jul 2013 @ 04:40 PDTDatabaseReplySynchronized scanningsorry, i did not read your comment correctly. for the row hash match join , the scan is going on as the join is happening --Shelley--  
1909 Jul 2013 @ 12:57 PDTDatabaseReplySynchronized scanningthe synchronized scanning is for pulling the data for building the hash join subtable, it is not part of the join itself. --Shelley--
1807 Jul 2013 @ 12:26 PDTDatabaseReplyMLPPI questionYou do not need to specify values for all partitioning columns to make use of an MLPPI. It will still be used if you only specify values for  one or two  of the partitioning columns . I...
1702 Jul 2013 @ 06:02 PDTDatabaseReplyApplications configurationIf you define a DNS name which points to all three IP's then you can use one name to always log on to the system. Even when one node is down
1620 Jun 2013 @ 04:09 PDTGeneralReplythe price of Teradata 14 Certification Exams These were the prices for the beta exams. vouchers were provided to qualified participants to reduce the cost to $99. As Deiter said, they will change when they become widely available.
1520 Jun 2013 @ 04:06 PDTGeneralReplyTeradata Optimization for large table(20 billion rows)The estimated time in an explain is actually a cost, not a time value (even though it says time). You cannot predict performance time by the number of amps. Performance time is affected by the har...
1411 Jun 2013 @ 12:18 PDTDatabaseReplySynchronized scanningthe answer to your question will be in the explain..what does the explain say. --Shelley  
1306 Jun 2013 @ 09:57 PDTDatabaseReplyProblems with dynamic creation of Volatile tablesVolatile tables and their data are only available to the session that creates them. They are not available to other sessions. Your friend needs to run the create volatile table (including the on c...
1204 Jun 2013 @ 07:38 PDTGeneralReplySame hash for different valuesAlso what you are trying to do is not going to provide any real value. You are using constants instead of true column values (whichtypically  have different data types and will therefore be h...
1103 Jun 2013 @ 07:23 PDTDatabaseReplyFirst connection teradata 14 after installationDid you make sure you ran the DIP step when creating your new database? Are you using DBC to logon to both BTEQ and through Teradata Administrator? --Shelley  
1003 Jun 2013 @ 06:56 PDTDatabaseReplyshow table dbc sourceIt gets the information from internal data structures  and in particular , for partitioning, it gets it from the table headers. --Shelley
902 Jun 2013 @ 11:01 PDTDatabaseReplyCreating a new secondary index on tableIt populates specific  columns in the dictionary tables.. Ie DBC.Indexes, etc
802 Jun 2013 @ 10:55 PDTDatabaseReplyWill the STATS be useful on below kind of data?Depending on the release you are on and the data type of the column , sample stats may not be very useful. If the column shown above is defined as character , it is larger than the 16 byte size th...
730 May 2013 @ 03:53 PDTGeneralReplyHow do you stop demoted queries from hogging CPU? How have you defined your penalty box cpu allocation? If there is no hard limit it can consume any available cpu on the system You also need to be aware that if you have many queries going into t...
628 May 2013 @ 07:46 PDTDatabaseReplyNeed more information about the temporary data retrival of TERADATA viewsthe result set from the view and anything that happens during the processing of the view (aggregations, etc)  go into spool. -- Shelley
527 May 2013 @ 06:37 PDTDatabaseReplyData Distribution SkewHi Nishant, if  a table is small then you do not need to worry about skew. It is unavaidable to have some skew and you do not need to worry about measuring it until you have at least several ...
409 May 2013 @ 06:52 PDTDatabaseReplySecondary indexesPartitioned primary indexes are great for large tables where you consistently access the data by some type or range, ie day, week, month as an example. These will reduce full table scans especially...

Pages