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
How is MLOAD Teradata Server restarted after execution?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
Explain the term 'row' related to relational database management system?
How would you load a very large file in teradata in general?
What is the difference between fastload and multiload? Which one is faster?
How is the teradata different from oracle?
How do you create tables? Exact syntax, and create profiles, users in teradata?
What is the syntax for case when statement?
What is upsert statement in teradata?
What are the components used in smp and massively parallel processing (mpp) machines?
Explain the term 'foreign key' related to relational database management system?
Can we collect statistics on multiple columns?
Explain how spool space is used.
What is the use of stored procedures in teradata?
What do you mean by teradata intellicloud?
