369 | 01 Jan 2014 @ 03:41 PST | Tools | Reply | When 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 ... |
368 | 01 Jan 2014 @ 03:08 PST | Tools | Reply | When 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... |
367 | 31 Dec 2013 @ 09:20 PST | Database | Reply | Unable to Create a Columnar Table after upgrading to 14 | Hi,
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... |
366 | 30 Dec 2013 @ 09:12 PST | Training | Reply | Regarding 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?
... |
365 | 29 Dec 2013 @ 05:13 PST | Database | Reply | Nested joins in Teradata | Hi,
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... |
364 | 29 Dec 2013 @ 05:07 PST | Training | Reply | Regarding 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... |
363 | 27 Dec 2013 @ 02:08 PST | Database | Reply | Table Partition | Hi 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... |
362 | 27 Dec 2013 @ 12:16 PST | Database | Reply | Table Partition | Hi 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... |
361 | 27 Dec 2013 @ 12:08 PST | Database | Reply | SELECT * not returning all columns | Bteq 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... |
360 | 27 Dec 2013 @ 06:26 PST | Database | Reply | extending MLPPI tables | Harpreet,
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 :)
|
359 | 27 Dec 2013 @ 05:35 PST | Database | Reply | Inserting 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... |
358 | 27 Dec 2013 @ 05:27 PST | Analytics | Reply | run queries in parallel and serial | In 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... |
357 | 27 Dec 2013 @ 04:49 PST | Tools | Reply | When 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... |
356 | 26 Dec 2013 @ 10:47 PST | Database | Reply | Fetching the data for thelast quarter dates | Hi Bikky,
What if you try this?
WHERE COL_NAME BETWEEN CURRENT_DATE AND ADD_MONTHS(CURRENT_DATE,-3)
|
355 | 26 Dec 2013 @ 09:46 PST | Database | Reply | Table Partition | Hi,
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_... |
354 | 26 Dec 2013 @ 09:36 PST | Database | Reply | extending MLPPI tables | HI,
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 ... |
353 | 24 Dec 2013 @ 04:32 PST | Database | Reply | Does one need unicode compression in Tredata 14.0 | Hi
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... |
352 | 24 Dec 2013 @ 04:30 PST | Database | Reply | Does one need unicode compression in Tredata 14.0 | Hi,
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 ... |
351 | 24 Dec 2013 @ 03:12 PST | Database | Reply | Query with TOP and COUNT | Hi Ratnam,
I have answered it on the other thread you have started:
http://forums.teradata.com/forum/database/top-function#comment-127912
|
350 | 24 Dec 2013 @ 03:09 PST | Database | Reply | Top Function | Hi 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... |
349 | 22 Dec 2013 @ 11:26 PST | Database | Reply | create set table vs. create multiset table | Hi,
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.
|
348 | 21 Dec 2013 @ 11:24 PST | General | Reply | Teradata Lock - 3 Insert Statements | Hi,
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... |
347 | 21 Dec 2013 @ 11:16 PST | Database | Reply | ON and WHERE clause for Joins | Hi,
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 ... |
346 | 21 Dec 2013 @ 02:14 PST | General | Reply | Identify tables whose partition has to be changed relatively to incorporate new year values in narrow window | Hi 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... |
345 | 21 Dec 2013 @ 01:52 PST | Database | Reply | TERADATA LOCK LEVELS | Hi,
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... |