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
What is TPD?
Difference between star and snowflake schemas?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
How do you see a ddl for an existing table?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
What are the frequently used data types in teradata?
What are the components provided on node?
What are default access rights in teradata?
Why does varchar occupy 2 extra bytes?
How many codd's rules are satisfied by teradata database?
Explain PDE.
How do you create tables? Exact syntax, and create profiles, users in teradata?
What is the use of having index on table?
What do you mean by caching in teradata?
Write a program to show the parser component used in teradata?