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
- 12811 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / yuvaevergreen
-->"Collect stats" collects demographic data about the
columns or indces of a table.
-->This statistics is used by the PE to optimize the plan
which can be viewed by explain command.
-->When collect stats is executed,the statistics is stored
in data for use of PE.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / tdguy
Stores the demographic data about the columns. Very
important for better performance.
| Is This Answer Correct ? | 2 Yes | 0 No |
what is a multi statement request in TD? what is the diif b/w V2R5 & TD12? what is the diff b/w MACRO & STORED PROCEDURE?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
What is use of compress in terdata?Explain?
What are the steps to create a data model?
What EXPLAIN does in Teradata, what is High confidence, Low confidence and No confidence.. And How we improve the query performance .
Explain amp in teradata?
one table have input no name 10 rao 20 siva 30 srinu 10 rao i want to ouput like this way no name 20 siva 30 srinu 10 rao how it posible in only sql server query?not oracle?
can I use “drop” statement in the utility “fload”?
2 Answers Accenture, CTS, NTT Data,
What is Difference b/w PI & PPI?how to implement PPI?
What is the basic syntax for teradata select statement?
What is differnce between Error code and Error Level in Bteq
IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.
Teradata 
