Interested to Buy Any Domain ? << Click Here >> for more details...
If the query is NOT WRITTEN PROPERLY then what are the recommendations you can give to the developer ?
- 1 Answers
- 5065 Views
- Teradata, I also Faced
- E-Mail Answers
Answer / tdguy
In TD, explain plan is like a gift to every developer.
Confidence levels should be observed (low, high or no).
Check for the recommendations of statistics. Try to observe
the plan for any product joins or nested joins. Avoid
unnecessary joins. Use secondary index and join indees
appropriately. Try to repeat the steps in the explain plan
after tuning.
| Is This Answer Correct ? | 7 Yes | 0 No |
How to select first n records in teradata?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
If the script is aborted. why it is aborted and how can you identify ?
What are teradata utilities?
Hello Frndz, I have a table named product as shown below: product_id product_name 1 AAA 1 BBB 1 CCC 2 PPP 2 QQQ 2 RRR Now my output should be: product_id product_name_1 product_name_2 product_name_3 1 AAA BBB CCC 2 PPP QQQ RRR
Explain the term 'columns' related to relational database management system?
When tpump is used instead of multiload?
Steps to create a data model?
What do you mean by teradata sql assistant?
In which phase of the Active Data Warehouse evolution do you use data to determine what will happen?
What is a level of granularity of a fact table?
List out teradata data types?
Teradata 
