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
What is the purpose of upsert command?
What is meant by a Parsing Engine?
How is the teradata different from oracle?
If RDBMS is halted what will you do ?
What are the primary characteristics of the Teradata.
How many tables can you join in v2r5?
Explain fallback in teradata?
List the logical and conditional operators that are used with teradata along with their meanings?
What is bteq utility in teradata?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
Highlight a few of the advantages that ETL tools have over Teradata.
What is database exceptions in teradata?
List out some of the primary characteristics of teradata.
What are the various indexes in teradata? Why are they preferred?
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?