What is collect State in Teradata ? what it use and how it
works??
- 3 Answers
- 12193 Views
- TCS, I also Faced
- E-Mail Answers
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
How do you see a ddl for an existing table?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What is the multi-insert?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
Highlight the points of differences between the database and user in Teradata.
What is the meaning of Caching in Teradata?
What does sleep function does in fast load?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
Explain vproc in teradata?
What is meant by a Parsing Engine?
What are the steps to create a data model?
What are the primary characteristics of the Teradata.
What is upsert statement in teradata?
Why teradata is used?
While creating table my dba has fallback or no fallback in his ddl. What is that?
