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
Highlight the advantages of PPI(Partition Primary Index).
What does sleep function does in fast load?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
What are the advantages of teradata?
What is the syntax for case when statement?
Explain the term 'foreign key' related to relational database management system?
List the logical and conditional operators that are used with teradata along with their meanings?
Highlight the points of differences between the database and user in Teradata.
What is spool space?
Write a program to show the parser component used in teradata?
What is meant by a node?
Difference between multiload and tpump?
What are different table types used in teradata?
How do you see a ddl for an existing table?
Explain the parallel data extension in teradata?