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
Can we collect statistics on table level?
In Teradata, how do we Generate Sequence?
Explain amp in teradata?
What is bteq utility in teradata?
How you will check the version of teradata?
What is a node in teradata?
Explain parsing engine in teradata?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
How to select first n records in teradata?
Why managing the data is important?
What are the various etl tools in the market?
Explain the new features of teradata?
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?
List out teradata data types?
What is meant by a Least Cost Plan?