What is collect State in Teradata ? what it use and how it
works??

Answer Posted / siri

The Optimizer plans an execution strategy for every
SQL query submitted to it. We have also seen that the
execution strategy
for any query may be subject to change depending on various
factors. For
the Optimizer to consistently choose the optimum strategy,
it must be
provided with reliable, complete, and current demographic
information
regarding all of these factors. The best way to assure that
the Optimizer
has all the information it needs to generate optimum
execution strategies
is to COLLECT STATISTICS.

-Statistics tell the Optimizer how many rows/ value there
are.
– The Optimizer uses statistics to plan the best way to
access data.
– May improve performance of complex queries and joins.
– NUSI Bit Mapping requires collected statistics.
– Helpful in accessing a column or index with uneven value
distribution.
– Stale statistics may mislead the Optimizer into poor
decisions.
– Statistics remain valid across a reconfiguration of the
system.
– COLLECT is resource intensive and should be done during
off hours.

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where is teradata rdbms used?

872


How is the teradata different from oracle?

838


What is the difference between fastload and multiload?

1034


How to find duplicates in a table?

883


What is smp and mpp platforms?

733


What is the difference between union and union all in teradata?

848


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

856


Explain teradata vs. Redshift?

775


Explain the parallel data extension in teradata?

851


What are the various indexes in teradata? Why are they preferred?

764


How to load specific no.of records using bteq, or fastload,or multiload

1533


Describe the set operators in teradata.

780


Why managing the data is important?

777


What does sleep function does in fast load?

850


Difference between inner join and outer join?

797