Can any one please provide me practical example of How to
do the performance tuning in Query??
Answer Posted / tdguy
Beauty of teradata lies in explain plan. It explains
everything about your query. Use it effectively to find the
opportunities for performance tuning.Avoid unnecessary
joins like product joins, use secondary index and collect
stats.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the frequently used data types in teradata?
What is the purpose of using case expression in teradata?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
How many types of joins are there in teradata?
Highlight the differences between Primary Key and Primary Index.
How do you see a ddl for an existing table?
Differentiate primary key and partition key?
Highlight the advantages of PPI(Partition Primary Index).
What is smp and mpp platforms?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
Highlight a few of the advantages that ETL tools have over Teradata.
What's the difference between timestamp (0) and timestamp (6)?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
Differentiate database data and data warehouse data?
What is oltp?