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 are the various etl tools in the market?
Difference between star and snowflake schemas?
List out teradata data types?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
How many types of joins are there in teradata?
What are the available primary index types in teradata.
Define views in teradata with general syntax.
Explain and compare pros and cons of start schemas?
Explain the meaning of Amp?
List out some of the primary characteristics of teradata.
What is the purpose of using case expression in teradata?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
How can you track login parameters of users in teradata?
What is the difference between fastload and multiload? Which one is faster?
why use references rather than pointers in the public api, particularly for arguments which are modified?
