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 is database exceptions in teradata?
What is the use of virtual processor connectivity in teradata?
How to find duplicates in a table?
What are the different table types supported by teradata?
What is meant by a Least Cost Plan?
What are the various indexes in teradata?
What is inner join and outer join?
What are tpump utility limitations?
What is the multi-insert?
What do you mean by fastexport in teradata?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
How is the teradata different from oracle?
What's the difference between timestamp (0) and timestamp (6)?
What is the command in bteq to check for session settings ?
Define views in teradata with syntax.