#DateForumTypeThreadPost
1225 Aug 2016 @ 04:49 PDTDatabaseReplyWhen to use Join Index Thanks Samir for your reply.
1125 Aug 2016 @ 09:32 PDTDatabaseReplyWhen to use Join Index Can anyone please help?
1023 Aug 2016 @ 05:32 PDTDatabaseReplyTeradata Implicit CastingThanks Fred. This document contains everything :)
923 Aug 2016 @ 06:16 PDTDatabaseReplyTeradata Implicit CastingNo. Say 2 tables table_a with column a byteint and other table_b with column b integer When they are joined together :   Select * from table_a join table_b on table_a.a=table_b.b What is ...
823 Aug 2016 @ 04:05 PDTDatabaseTopicWhen to use Join Index Hi , What are the indications from the explain plan of a query that might indicate we should use a JI [ aggregate,sparse,single table or multi table ]? Thanks, Agnit
722 Aug 2016 @ 07:13 PDTDatabaseTopicTeradata Implicit CastingHi, I was just curious to know what would happen when 2 columns with different data types integer and byteint is joined together? According to me the byteint should be converted to integer. Howev...
623 Jul 2016 @ 08:50 PDTDatabaseReplyCreate a table with a date column that has a defaultTO_DATE is oracle specific function not supported in Teradata.
522 Jul 2016 @ 04:59 PDTDatabaseReplyConsequential inserts into large fact table performing very slow inside stored Procedure1) Views will use the same PI as the base tables in joins. 2) I think it is in fact possible to use Volatile Tables in Stored Procedures.  3) For performance improvement you can have a look ...
422 Jul 2016 @ 04:55 PDTDatabaseReplyVolatile Tables in MacrosYes possible.
322 Jul 2016 @ 04:40 PDTDatabaseReplyHow to calculate minimum & maximum values based on a column only if the records are continuousWith period data type using EXPAND ON clause it might provide the necessary output.   Agnit.
222 Jul 2016 @ 04:32 PDTDatabaseReplyMerge into operationI think it's possible. Don't such see any such constraints why it won't be possible. But got to mention all the tgt PI columns in the join condition. Agnit
119 May 2016 @ 10:09 PDTTrainingTopicTE0-142 Study HelpHi, I am mostly done with all the topics required for the TE0-142 exam except the "SQL Optimization Concepts" part. Can anyone please provide me some links from where I can get the requ...