What is Join Index in TD and How it works?
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
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
How does hashing happens in teradata?
What are the steps involved after the disk manager passes the request?
What is teradata?
any one answer me how they can analyzing the project using data ware housing?
What is teradata and why it is used?
Highlight the need for Performance Tuning.
What is a three-tier data warehouse?
What are tpump utility limitations?
How to view every column and the columns contained in indexes in teradata?
What is upsert statement in teradata?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
What is inner join and outer join?
What are different table types used in teradata?
Why does varchar occupy 2 extra bytes?