How to improve the query performance without taking the
collect statistics? In explain plan i have 'NO CONFIDENT'.
Answer Posted / 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 |
Post New Answer View All Answers
What are the primary characteristics of the Teradata.
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
Different phases of multiload?
What can be achieved by using the teradata rdbms?
how do you manage the production space. what are the proactive methods you can take ?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
How to load specific no.of records using bteq, or fastload,or multiload
What is teradata? What are some primary characteristics of teradata?
What are the functions involved in shared information architecture?
What is meant by a Least Cost Plan?
What are aggregate tables? How do you design them using teradata?
What is the use of stored procedures in teradata?
How to find duplicates in a table?
What are the string manipulation operators and functions associated with teradata?
What are the things to be considered while creating secondary index?