Interested to Buy Any Domain ? << Click Here >> for more details...
How does indexing improve query performance?
- 4 Answers
- 20866 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / guru
ONE LINE ANSWER: INdexing acts as SET option (Where clause)
while an query is being executed provided the query
contains these indexes.
Guru,
Advanced Teradata Certified Professional
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
Mention a few of the ETL tools that come under Teradata.
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
What are the available primary index types?
What are the steps involved after the disk manager passes the request?
What are the main components of teradata system?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
What is the difference between union and union all in teradata?
What are the design features involved in teradata?
What is the purpose of using case expression in teradata?
What are the things to be considered while creating secondary index?
What are the various indexes in teradata? How to use them?
Difference between star and snowflake schemas?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
What is the purpose of joins in teradata and what are the available join types?
