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
- 6599 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
What is the purpose of joins in teradata?
What is a level of granularity of a fact table?
How do you do backup and recovery in teradata?
How do you see a ddl for an existing table?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What is meant by a Highest Cost Plan?
Differentiate database data and data warehouse data?
What is the maximum number of dml can be coded in a multiload script?
What are the different methods ot loading a dimension table? A fact table etc?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
What are the available join types in teradata?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What are the uses of bynets in multi-node systems?
Different phases of multiload?
if collect stats but it show low confidence why?
