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
What are tpump utility limitations?
any one answer me how they can analyzing the project using data ware housing?
What is the command in bteq to check for session settings ?
What is the use of teradata system software?
What is the multi-insert?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
What is difference between user and database in teradata?
What are the different methods ot loading a dimension table? A fact table etc?
How to view every column and the columns contained in indexes in teradata?
How many tables can you join in v2r5?
What are the steps involved in the process flow of the sql statement through channel attached system?
What is the primary index in teradata?
What is database exceptions in teradata?
What is the difference between union and union all in teradata?
What is a level of granularity of a fact table?