What is Join Index in TD and How it works?
Answer Posted / kiran
It is an indexing structure containing columns from one or
more base tables.
supose one query frequently request a perticular join on
multiple tables that is recomdable.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
what are the day to day activities of teradata DBA ?
What is the difference between union and union all in teradata?
Highlight the limitations of TPUMP Utility.
What do you mean by tpt in teradata?
Explain some differences between mpp and smp?
What is the use of fallback?
Explain the meaning of Amp?
Explain Teradata performance tuning and optimization?
What is called partitioned primary index (ppi)?
What is the use of virtual processor connectivity in teradata?
What is dimensional modeling?
Difference between inner join and outer join?
what is sysdba and sysdbc ? which has high priority ?
What is the purpose of using case expression in teradata?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!