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

Explain fallback in teradata?

984

What is logical data model?

1137

What are the components provided on node?

984

Define views in teradata with syntax.

1021

How to find duplicates in a table?

1131

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

1089

Can we collect statistics on multiple columns?

986

What is spool space?

1071

What are the various indexes in teradata? How to use them?

953

Explain how spool space is used.

1017

What is a level of granularity of a fact table?

1069

What is teradata?

1059

Explain teradata architecture in detail with a diagram.

1046

What are differences between teradata and ansi session modes in teradata?

1093

What are some commonly used bteq scripts?

942