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 do you mean by fastexport in teradata?
What interface is used to connect to windows based applications?
What are the functions of a teradata dba?
What is smp and mpp platforms?
How to load specific no.of records using bteq, or fastload,or multiload
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
What are the available join types in teradata?
What is difference between user and database in teradata?
Differentiate database data and data warehouse data?
What are the updated features of teradata?
What is the difference between fastload and multiload?
How many codd's rules are satisfied by teradata database?
Steps to create a data model?
What is the command in bteq to check for session settings ?
Which is more efficient group by or distinct to find duplicates?
