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 is the purpose of using case expression in teradata?
How to find duplicates in a table?
how do you manage the production space. what are the proactive methods you can take ?
What are the different functions performed in development phase?
What do you mean by parsing?
What are the functions performed by bynet?
Comment whether bottleneck is an error or not.
What is upsert statement in teradata?
What is a dimension table?
What is bteq utility in teradata?
What is database exceptions in teradata?
Explain the term 'primary key' related to relational database management system?
What are the advantages of teradata?
What is the use of having index on table?
How to eliminate product joins in a teradata sql query?