#DateForumTypeThreadPost
36901 Jan 2014 @ 03:41 PSTToolsReplyWhen are secondary indexes required?San, Can you please confirm how much data do you have in this table? The optimizer will always go for the most optimal plan, if it finds that scanning all partitions is more efficient than using ...
36801 Jan 2014 @ 03:08 PSTToolsReplyWhen are secondary indexes required?Hi San, Yes, PI will lead you to single AMP but will probe all the partitions. Thats why it is recomended to use NUSI consisting of same solumns as NUPI on top of PPI. and when this NUSI is access...
36731 Dec 2013 @ 09:20 PSTDatabaseReplyUnable to Create a Columnar Table after upgrading to 14Hi,   I beleive the default DBS control parameter setting for Default Primary Index  is D or P which means the table will be created with first column as NUPI. To have a columnar d...
36630 Dec 2013 @ 09:12 PSTTrainingReplyRegarding Certification Exams - Pass %Ashok, Basically TD University is available for Teradata employees only. I guess you will have to contact your IT department to get info or access to that portal. Are you an employee of teradata? ...
36529 Dec 2013 @ 05:13 PSTDatabaseReplyNested joins in TeradataHi, Nested joins are the most efficient join types used in Teradata. They are mostly useful with OLTP requests.  In a nested join a row is selected from one table using an equality condition...
36429 Dec 2013 @ 05:07 PSTTrainingReplyRegarding Certification Exams - Pass %Hi Srinithy, Most of the info is available at the Teradata certification website. You can check the price of each exam by vsisting the prometric website. http://prometric.com/en-us/clients/terada...
36327 Dec 2013 @ 02:08 PSTDatabaseReplyTable PartitionHi Sharat, Yes, it is due the fact the use of expression in RANGE_N can prohibit the optimizer to eliminate the partitions and it does a full table scan. So partitions are there, but the way parti...
36227 Dec 2013 @ 12:16 PSTDatabaseReplyTable PartitionHi Sharat, Here is the answer to your question: http://www.info.teradata.com/htmlpubs/DB_TTU_14_00/index.html#page/Database_Management/B035_1094_111A/ch09.050.084.html   See the lines: Yo...
36127 Dec 2013 @ 12:08 PSTDatabaseReplySELECT * not returning all columnsBteq used to show the column headers with the same number of characters as defined in column definition. In ou case Bteq is returning all the columns but the output is being truncated due to comma...
36027 Dec 2013 @ 06:26 PSTDatabaseReplyextending MLPPI tablesHarpreet, Future empty partitions will not impact performance in TD 14. all you can do is to keep the stats updated. So that optimizer knows about the empty partitions :)  
35927 Dec 2013 @ 05:35 PSTDatabaseReplyInserting to a table incrementally Bikkey,   Can you please tell whether the source is containing 1 million rows and you wnat to pick 100,000 rows according to some criteria?   Or the source will be load...
35827 Dec 2013 @ 05:27 PSTAnalyticsReplyrun queries in parallel and serialIn a multistatement request, it is optimizer's decision to either execute the steps in serial or in parallel.  If your requests are indepedent of each other you can use explain to see how...
35727 Dec 2013 @ 04:49 PSTToolsReplyWhen are secondary indexes required?Hi Arash,   Secondary indexes are mostly used to improve acces on the queries that use a non PI column in search conditions. Following are some common uses of SI: If a non PI column...
35626 Dec 2013 @ 10:47 PSTDatabaseReplyFetching the data for thelast quarter datesHi Bikky, What if you try this? WHERE COL_NAME BETWEEN CURRENT_DATE AND ADD_MONTHS(CURRENT_DATE,-3)  
35526 Dec 2013 @ 09:46 PSTDatabaseReplyTable PartitionHi,   There are some points to notice about your query: The first thing is you have a defined PI on (PLCY_NBR, MPD_ID) but you are using a partial value in your where clause using only MOD_...
35426 Dec 2013 @ 09:36 PSTDatabaseReplyextending MLPPI tablesHI, You can use alter table statement to alter partitions on an empty table in any way, but there are certian limitations when the table is populated. When the table is populated, You can add or ...
35324 Dec 2013 @ 04:32 PSTDatabaseReplyDoes one need unicode compression in Tredata 14.0Hi I was going through some material and I came to know that TRANSUNICODETOUTF8 can only be used to compress UNICODE columns which contain ASCII LATIN 7 Bit data. So I guess if TD 14 is to store U...
35224 Dec 2013 @ 04:30 PSTDatabaseReplyDoes one need unicode compression in Tredata 14.0Hi, I was going through some material and I came to know that TRANSUNICODETOUTF8  can only be used to compress UNICODE columns which contain ASCII LATIN 7 Bit data. So I guess ...
35124 Dec 2013 @ 03:12 PSTDatabaseReplyQuery with TOP and COUNTHi Ratnam, I have answered it on the other thread you have started: http://forums.teradata.com/forum/database/top-function#comment-127912  
35024 Dec 2013 @ 03:09 PSTDatabaseReplyTop FunctionHi Ratnam, In a Sample n function, the amps will choose rows in some random fashion. So there is no need to sort the rows. In TOP n function the rows are sorted first and then the top n rows spec...
34922 Dec 2013 @ 11:26 PSTDatabaseReplycreate set table vs. create multiset tableHi, If you have unique index defined on a table, then duplicate row check will be performed at index level, and multiset and set table will not make any difference.
34821 Dec 2013 @ 11:24 PSTGeneralReplyTeradata Lock - 3 Insert StatementsHi, This is a basic transactional processing mechanism that every database adopts to avoid deadlocks. If multiple statements are trying to write the same object they will be processed sequentially...
34721 Dec 2013 @ 11:16 PSTDatabaseReplyON and WHERE clause for JoinsHi,  I was trying to find some good source of information to check this syntax, finally I found the below document which describes that this syntax can only be used with inner joins, See the ...
34621 Dec 2013 @ 02:14 PSTGeneralReplyIdentify tables whose partition has to be changed relatively to incorporate new year values in narrow windowHi Cheeli, What I have understand from your explaination is that you want to dynamically update all the prtitions to the current date, according to the defined partitions. To handle such a scenari...
34521 Dec 2013 @ 01:52 PSTDatabaseReplyTERADATA LOCK LEVELSHi, You can consult the following document and you will get all the answers to your query: http://www.info.teradata.com/htmlpubs/DB_TTU_14_00/index.html#page/General_Reference/B035_1091_111A/ch11...

Pages