Use execution plan and try to analyze the execution steps. Try to tune th

How to improve the query performance without taking the
collect statistics? In explain plan i have 'NO CONFIDENT'.

Question Posted / tdguy

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

Please Help Members By Posting Answers For Below Questions

What are the primary characteristics of the Teradata.

1058

What do you mean by parsing?

1057

How do you create tables? Exact syntax, and create profiles, users in teradata?

973

How to run a query in teradata?

1007

What are teradata utilities?

1032

What are the different table types that are supported by teradata?

954

What are the uses of bynets in multi-node systems?

968

What is teradata?

1059

Why managing the data is important?

956

What is the syntax for case when statement?

1054

If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

2098

Describe primary index in teradata?

956

What are the different functions included in the server software?

978

Explain the term 'foreign key' related to relational database management system?

956

How can bottlenecks be identified?

955