Interested to Buy Any Domain ? << Click Here >> for more details...
How to improve the query performance without taking the
collect statistics? In explain plan i have 'NO CONFIDENT'.
- 2 Answers
- 6821 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 |
1)WHAT IS THE EXACT DIFFERENCE BETWEEN TERADATA AND ORACLE? 2)MOST OF THE COMPANIES ARE USING TARA DATA FOR "DWH PROJECTS" ONLY? WHY?
6 Answers Bank Of America, Wipro,
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
How to copy 1 million records from one DB to another, Which is effective interms of performance?
What is inner join and outer join?
What is meant by a Highest Cost Plan?
What is the difference between union and union all in teradata?
How to eliminate product joins in a teradata sql query?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
What is node? How many nodes and amps used in your previous project?
What are the steps to create a data model?
Can any one plz provide the teradata interview questions?
Can we Suggest as how is the process to get a job in teradata in current market??Is it easier???
Teradata 
