Interested to Buy Any Domain ? << Click Here >> for more details...
Can any one please provide me practical example of How to
do the performance tuning in Query??
- 5 Answers
- 11832 Views
- Amdocs, I also Faced
- E-Mail Answers
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
How can you track login parameters of users in teradata?
How do you see a ddl for an existing table?
What is spool space? Why do you get spool space errors?
What is the purpose of using case expression in teradata?
During the Display time, how is the sequence generated by Teradata?
What are the joins in teradata and how many types of joins are there in teradata?
What is node? How many nodes and amps used in your previous project?
What are the steps involved after the disk manager passes the request?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
Highlight the differences between Primary Key and Primary Index.
What are the uses of bynets in multi-node systems?
What is the command in bteq to check for session settings ?
Is multi insert ansi standard?
how can we analyze the locks ?
Explain some differences between mpp and smp?
