How does indexing improve query performance?
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
What is oltp?
What is database exceptions in teradata?
Mention a few of the ETL tools that come under Teradata.
What is the maximum number of dml can be coded in a multiload script?
What are the primary characteristics of the Teradata.
Write a program to show the parser component used in teradata?
What are the various etl tools in the market?
What are the different table types supported by teradata?
any one answer me how they can analyzing the project using data ware housing?
what is object level locking ? where do appear this type of locking ?
What are the various reporting tools in the market?
What do you mean by tpt in teradata?
What is the command in bteq to check for session settings ?
In Teradata, what is the significance of UPSERT command?
What are the available primary index types?