Interested to Buy Any Domain ? << Click Here >> for more details...
How does indexing improve query performance?
- 4 Answers
- 20663 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / praveen
By creating index on single or multiple columns, query
takes index access path instead of full table scan. Full
table scan is costilier operation where it has to visit all
rows in the table whereas index operation just accesses the
index sub table with required hash value and joins with the
basetable using rowid. This improves response time and
performance of the query.
| Is This Answer Correct ? | 28 Yes | 3 No |
Post New Answer View All Answers
Write a program to show the parser component used in teradata?
Highlight the advantages of PPI(Partition Primary Index).
why use references rather than pointers in the public api, particularly for arguments which are modified?
What does sleep function does in fast load?
Did you write stored procedures in teradata?
Explain some differences between mpp and smp?
What is the difference between fastload and multiload? Which one is faster?
What are some primary characteristics of teradata?
What is bteq utility in teradata?
Highlight a few of the advantages that ETL tools have over Teradata.
What is the meaning of Caching in Teradata?
Differentiate primary key and partition key?
What is teradata? Also, list out some of the primary characteristics of teradata.
Give a justifiable reason why Multi-load supports NUSI instead of USI.
What exactly do you know about catching in teradata?
