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

What are some primary characteristics of teradata?

1050

What is teradata? Also, list out some of the primary characteristics of teradata.

1123

Why managing the data is important?

1056

Name the five phases that come under MultiLoad Utility.

1025

What do you mean by teradata intellicloud?

1074

Where is teradata rdbms used?

1137

In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

1241

What is a clique?

1152

Explain BYNET.

1053

What is difference between user and database in teradata?

1114

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2467

What are aggregate tables? How do you design them using teradata?

1216

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

4600

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

1034

What is teradata? What are some primary characteristics of teradata?

1026