How to improve the query performance without taking the
collect statistics? In explain plan i have 'NO CONFIDENT'.
- 2 Answers
- 5913 Views
- I also Faced
- E-Mail Answers
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
If RDBMS is halted what will you do ?
What are the things to be considered while creating secondary index?
What are the available join types in teradata?
What type of indexing mechanism do we need to use for a typical data warehouse?
What are differences between teradata and ansi session modes in teradata?
What is the function of parser component in teradata?
Syntax for case when statement?
What is multi insert?
Explain and compare pros and cons of start schemas?
What is basic teradata query language?
What are the 5 phases in a multiload utility?
What is the difference between teradata and oracle?
If a Node is busy what are the steps you can take to avoid ?
Why are oltp database designs not generally a good idea for a data warehouse?
What is a three-tier data warehouse?
