How to improve the query performance without taking the
collect statistics? In explain plan i have 'NO CONFIDENT'.
- 2 Answers
- 5752 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / yuvaevergreen
Probably, we can try splitting the query by using volatile tables and tuning the query.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / tdguy
Use execution plan and try to analyze the execution steps.
Try to tune the query. Use secondary index or join index
appropriately, if necessary.
| Is This Answer Correct ? | 2 Yes | 0 No |
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
Why Multiload does not supports USI and supports NUSI?
Explain teradata architecture in detail with a diagram.
Explain teradata utilities?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
I Have Name field in a Table Name ------------- abcde;fgh;ijk; abc;def;jklm;no I want to write a sql to display name field data with out ';'.so i want to replace ; with '' how will write in Teradata
In the Primary Index, what is the score of AMPs that are actively involved?
Syntax for case when statement?
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 is partitioned primary index (ppi)?
IN A TABLE CAN WE USE PRIMARY KEY IN ONE COLUMN AND IN ANOTHER COLUMN BOTH UNIQUE AND NOT NULL CONSTRAINS.IF YES HOW?PLZ GIVE ME A EXAMPLE.
How do you eliminate duplicates?
Teradata 
