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
Steps to create a data model?
What is dimensional modeling?
What is TPD?
What is database exceptions in teradata?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
Explain teradata architecture in detail with a diagram.
Different phases of multiload?
Highlight the points of differences between the database and user in Teradata.
Comment whether bottleneck is an error or not.
What is primary index and secondary index?
any one answer me how they can analyzing the project using data ware housing?
why use references rather than pointers in the public api, particularly for arguments which are modified?
Difference between inner join and outer join?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?