Probably, we can try splitting the query by using volatile tables and tunin

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

Question Posted / yuvaevergreen

Answer Posted / yuvaevergreen

Probably, we can try splitting the query by using volatile tables and tuning the query.

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

2204

What is a node in teradata? Explain

1009

How can we check the version of Teradata that we are using currently?

1069

What is bteq script in teradata?

1155

What are the updated features of teradata?

1046

What are the steps to create a data model?

1053

Explain the types of join supports by teradata?

995

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

1003

How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

4373

How do you determine the number of sessions?

1064

What is the purpose of indexes?

1077

What is the use of virtual processor connectivity in teradata?

1032

How many codd's rules are satisfied by teradata database?

1112

What are some commonly used bteq scripts?

1012

Different phases of multiload?

1013