Join index stores the joined rows to two or more tables in the permanent s

What is Join Index in TD and How it works?

Question Posted / yuvaevergreen

6 Answers
35949 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

Please Help Members By Posting Answers For Below Questions

What do you mean by teradata intelliflex?

1036

Explain teradata architecture?

1031

Comment whether bottleneck is an error or not.

1073

Explain teradata utilities?

981

What are aggregate tables? How do you design them using teradata?

1092

Explain the term 'row' related to relational database management system?

886

What are the various indexes in teradata?

968

What is bteq script in teradata?

1077

What are the steps involved in the process flow of the sql statement through channel attached system?

1051

Explain teradata vs. Redshift?

956

Explain the term 'database' related to relational database management system?

929

What is the purpose of upsert command?

1078

How to view every column and the columns contained in indexes in teradata?

980

What do you mean by caching in teradata?

995

What are differences between teradata and ansi session modes in teradata?

1094