Interested to Buy Any Domain ? << Click Here >> for more details...
What is Join Index in TD and How it works?
- 6 Answers
- 36515 Views
- BT, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / tdguy
In this join index table, rows from two or more tables are
joined and stored in perm space. This table is updated
whenever the underlying rows are modified in the base
tables. These indexes can be very much useful for the
frequent queries. Advantage is faster processing.
Disadvantage is use of space and whenever join involves
atleast one column out of this join index, then this index
table would be of no use. Entire join would have to be done
separately.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What are some commonly used bteq scripts?
Explain the parallel data extension in teradata?
What is difference between user and database in teradata?
Explain how spool space is used.
Explain the new features of teradata?
Is multi insert ansi standard?
How many types of joins are there in teradata?
How to find duplicates in a table?
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?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
What is the primary index in teradata?
what are the day to day activities of teradata DBA ?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
What do you mean by parsing?
Explain parsing engine in teradata?
