Interested to Buy Any Domain ? << Click Here >> for more details...
What is Join Index in TD and How it works?
- 6 Answers
- 36273 Views
- BT, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
Join index stores the joined rows to two or more tables in
the permanent space. Not beneficiary always. Space
consumptions may be a problem. Can be used whenever large
tables are consistently and frequently joined and space may
not be a problem.
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
Describe the between keyword in teradata?
What is the use of fallback?
What is a clique?
What are the string manipulation operators and functions associated with teradata?
In BTEQ, how are the session-mode parameters being set?
How to eliminate product joins in a teradata sql query?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What type of indexing mechanism do we need to use for a typical data warehouse?
What happens when a node suffers a downfall?
What is the purpose of upsert command?
Explain fallback in teradata?
How can you track login parameters of users in teradata?
Explain the most common data types used in teradata?
In the Primary Index, what is the score of AMPs that are actively involved?
What is primary index and secondary index?
