Interested to Buy Any Domain ? << Click Here >> for more details...
What is Join Index in TD and How it works?
- 6 Answers
- 35958 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
Explain the term 'database' related to relational database management system?
What is the opening step in basic teradata query script?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
What are the available join types in teradata?
What is spool space?
Explain how spool space is used.
What is the basic syntax for teradata select statement?
What are the different methods ot loading a dimension table? A fact table etc?
What are the multiload utility limitations?
How many types of joins are there in teradata?
How many tables can you join in v2r5?
What is the difference between union and union all in teradata?
What is meant by a Parsing Engine?
What are some primary characteristics of teradata?
What are the different functions included in the server software?
