Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sivareddy
si it avoids the full table scan nd it gives the fast reterival of the data and use the extra perm space where as join index it holds the one or more then tables data nd stored in perm space.at the time of joined two table it will take data from join index.and also it will use aggregate operations,anylatical operations.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Which is faster fastload or multiload?
How to load specific no.of records using bteq, or fastload,or multiload
Highlight the differences between Primary Key and Primary Index.
List out teradata data types?
Describe primary index in teradata. And what are the available primary index types?
Explain the term 'foreign key' related to relational database management system?
What are the joins in teradata?
What are the 5 phases in a multiload utility?
What is partitioned primary index (ppi)?
What are the different table types that are supported by teradata?
What are default access rights in teradata?
What are the updated features of teradata?
What is node? How many nodes and amps used in your previous project?
What is basic teradata query language?
How to Extract data from multiple legacy systems?
