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

While creating table my dba has fallback or no fallback in his ddl. What is that?

1155

what are the uses of fact table and dimension table in banking project?

4540

How do you define Teradata?

1021

What is a three-tier data warehouse?

1093

What are the components used in smp and massively parallel processing (mpp) machines?

1041

What is the purpose of indexes?

1044

Which is more efficient group by or distinct to find duplicates?

1070

Is multi insert ansi standard?

2186

How many tables can you join in v2r5?

1048

What is multi insert?

1032

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

1015

What is bteq script in teradata?

1134

What are the commands to make a new table, change a table and remove a table in teradata?

1110

What is meant by a Parsing Engine?

1169

What is inner join and outer join?

1088