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
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
How many sessions of MAX is PE capable of handling at a particular time?
Describe the set operators in teradata.
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
Highlight all the modes that are present under Confidence Level.
What are normalization, first normal form, second normal form and third normal form?
How to run a query in teradata?
What is spool space?
what are the day to day activities of teradata DBA ?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What's the difference between timestamp (0) and timestamp (6)?
What are differences between teradata and ansi session modes in teradata?
What interface is used to connect to windows based applications?
Can you connect multiload from ab initio?
If a Node is busy what are the steps you can take to avoid ?