316 | 08 Sep 2016 @ 12:08 PDT | Database | Reply | Rules for Multi value compression | 1. no MVC on PIs
2. Can have MVC on as many columns as desired, no such thing as too many columns. If there is a very large number of very large values, it is possible to exceed the total space li... |
315 | 07 Sep 2016 @ 07:59 PDT | Database | Reply | Teradata block storage | Correct. The row index list is just a set of offsets from the beginning of the block rather than a pointer but the effect is the same.
|
314 | 06 Sep 2016 @ 07:25 PDT | Database | Reply | Teradata block storage | The rows in the data blocks are not sorted, they are just placed at the end of a heap of storage. The block contains an index list though which is ordered by the rowid. Likewise the blocks are not ... |
313 | 01 Sep 2016 @ 10:46 PDT | Database | Reply | between condition make bad execution plan | What is the result of select count(*) from tbla where TheDay < '2014-08-01'? Trying to exclude the rows in tbla that cannot match from the product join.
Is the desir... |
312 | 01 Sep 2016 @ 09:04 PDT | Database | Reply | between condition make bad execution plan | What described above requires the product join, every row of b compared to every row of a. This is going to be expensive for a medium table joined to a large table. Are you sure the... |
311 | 31 Aug 2016 @ 12:46 PDT | Data Modeling | Reply | How to transform an LDM to a PDM / Building block or Datamart? | Either - depends on the bsuiness requirements. Generally the business requires the history of an account so it would be likely that Account is defined to save the expired rows. Events however often... |
310 | 30 Aug 2016 @ 05:50 PDT | Viewpoint | Reply | Is there a way to control RESPONDING STATE of large extracts using TASM Exceptions? | The result spool is not sent to BYNet. The BYNet is sent a reference to it where it was created by the last step of the plan. The result spool stays in the user's spool space until it is releas... |
309 | 28 Aug 2016 @ 06:42 PDT | Database | Reply | Inserting into table using multiple common table expressions CTE | Teradata only supports one WITH. But within the one WITH it is possible to specify as many CTEs as desired.
|
308 | 26 Aug 2016 @ 04:00 PDT | Database | Reply | PPI | It is generally better to start a new thread for a new question...
It is correct that a UPI cannot be defined when it does not contain the partitioning column. This is because enforcing th... |
307 | 26 Aug 2016 @ 09:48 PDT | Private Forum |
306 | 26 Aug 2016 @ 09:37 PDT | Analytics | Reply | Query_Discussion_HELP | Please provide query and Explain.
|
305 | 26 Aug 2016 @ 09:25 PDT | Database | Reply | Teradata: No more room in journal table for novaquality.journals | A SHOW table on the target table will showthe database location for the journals. It is possible the journals are in a different database that is out of space even if the database containing t... |
304 | 23 Aug 2016 @ 06:15 PDT | Database | Reply | Can we pass object as parameter in a macro ? | Macro parameters are designed for constant substitution only. They can appear only in the places in a statment where a constant value can appear (and not every one of those either - like options in... |
303 | 18 Aug 2016 @ 08:12 PDT | Tools | Reply | Getting export results in same date format as in Teradata table using BTEQ | Please provide the SHOW TABLE. Need to see the data type and format for the column that contains the date.
|
302 | 09 Aug 2016 @ 05:42 PDT | General | Reply | Improve performance on an analytical query , mulitple columns using same set of partitions | As you can see, optimizer combines multiple ordered analytic functions with the same partition and order into a single execution. Two different ones are required because there are two d... |
301 | 08 Aug 2016 @ 10:32 PDT | General | Reply | Improve performance on an analytical query , mulitple columns using same set of partitions | Can you provide explain please? |
300 | 04 Aug 2016 @ 10:49 PDT | Private Forum |
299 | 03 Aug 2016 @ 05:59 PDT | Database | Reply | Distibution of Small table (rows less than number of amps) to single amp for Performance | If the system has a very large number of AMPs, this technique can remove all-AMP steps from the query plans which access the table. If the queries that access the table are even medium size, the di... |
298 | 03 Aug 2016 @ 05:49 PDT | Database | Reply | Keeps returning zeros for decimal | 60 is an integer and when column1 is also an integer, integer division is performed which does not result in any fractional portion. Using 60. or casting either column1 or 60 to decimal will resolv... |
297 | 03 Aug 2016 @ 05:44 PDT | Tools | Reply | Export with header using TPT | If the UNION form is used, it is a good idea to use UNION ALL so that the engine is not forced to do a duplicate elimination pass over the combination of the header row and the data.
|
296 | 01 Aug 2016 @ 06:57 PDT | Database | Reply | Multiload | The same way any data is loaded. A souce is decribed that contains the PI values to delete and multiload is told to load those PIs and then use them to delete rows.
|
295 | 29 Jul 2016 @ 12:17 PDT | Private Forum |
294 | 27 Jul 2016 @ 02:31 PDT | Database | Reply | Multiload | There are two different forms of delete in Multiload which may be the source of confusion.
Multiload Delete Task accepts a DELETE statement with a where clause intended to bulk delete the ... |
293 | 19 Jul 2016 @ 09:10 PDT | Tools | Reply | Determine #sessions to set for load / exp jobs | Better yet, let WLM manage the number of sessions and only change the ones that really need exceptions via WLM rules.
|
292 | 19 Jul 2016 @ 09:07 PDT | Tools | Reply | In List Blues - How to make large In List Queries More Efficient | What Teradata release is being used?
What does the explain plan look like for the 4500 class case?
On current releases, the Teradata optimizer should be doing this automatically. ... |