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
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
What are the functions of a teradata dba?
In the Primary Index, what is the score of AMPs that are actively involved?
How to Extract data from multiple legacy systems?
What is the maximum number of dml can be coded in a multiload script?
How do you set the session mode parameters in bteq?
Explain the teradata primary index mechanics in detail with a diagram.
What is the purpose of indexes?
What is a clique?
How to select first n records in teradata?
What is basic teradata query language?
What are the various indexes in teradata? How to use them?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
How would you load a very large file in teradata in general? What utility would you use for it? Why?
How can bottlenecks be identified?
