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
- 4955 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 |
What are the different methods ot loading a dimension table? A fact table etc?
Can you connect multiload from ab initio?
Hi frnds...can any one help me regarding this que.. We have column in a table name it as C1 WHICH CONTAIN ALPHANUMERIC AND NUMERIC VALUES. C1 2A 2B 2V 2H 1 2 3 4 5 i want to retrive numeric values like 1,2,3,4,5 How we can get Plz let me know.Thanks in advance
What is meant by a Virtual Disk?
What are the joins in teradata?
Can we collect statistics on table level?
I have all the TERADATA Certification Dumps for the below: NR0-011, NR0-012, NR0-013, NR0-014 NR0-015 NR0-016, NR0-017 If anyone need it, pls drop me a mail with Code in the mail to: terashish@gmail.com
201 Answers Cognizant, Deloitte, IBM, Prometric, Syntel,
What are aggregate tables? How do you design them using teradata?
What are the components used in smp and massively parallel processing (mpp) machines?
What are the various indexes in teradata? How to use them?
why should we go Teradata over Oracle,what is the main differences?
which option is used to restart the fast load script?
Teradata 
