Interested to Buy Any Domain ? << Click Here >> for more details...
What is collect State in Teradata ? what it use and how it
works??
- 3 Answers
- 12762 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 to find duplicates in a table?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What is the use of fallback?
Discuss the advantages of using partitioned primary index in a query?
What are different table types used in teradata?
Explain the types of join supports by teradata?
Difference between multiload and tpump?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
What is meant by a Clique?
What does Amp contain and what are all the operations that it performs?
What are some commonly used bteq scripts?
How many sessions of MAX is PE capable of handling at a particular time?
If RDBMS is halted what will you do ?
Explain the new features of teradata?
What is database exceptions in teradata?
