Interested to Buy Any Domain ? << Click Here >> for more details...
What is Join Index in TD and How it works?
- 6 Answers
- 36232 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
Explain teradata architecture?
Highlight a few of the advantages that ETL tools have over Teradata.
What are the various indexes in teradata? How to use them?
What is the primary index in teradata?
Explain the term 'database' related to relational database management system?
What is the difference between union and union all in teradata?
Explain some differences between mpp and smp?
What are default access rights in teradata?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
Explain teradata vs. Redshift?
What are the components used in smp and massively parallel processing (mpp) machines?
Explain the meaning of Amp?
What can be achieved by using the teradata rdbms?
If a Node is busy what are the steps you can take to avoid ?
What is spool space? Why do you get spool space errors?
