What is collect State in Teradata ? what it use and how it
works??
Answer Posted / 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 |
Post New Answer View All Answers
What are the newly developed features of Teradata?
How will you solve the problem that occurs during update?
What do you mean by teradata intellicloud?
What are the functions of a Parser?
What are the frequently used data types in teradata?
How is the teradata different from oracle?
How to run a query in teradata?
What are the string manipulation operators and functions associated with teradata?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
What is teradata and why it is used?
Why is the case expression used in teradata?
Explain the term 'columns' related to relational database management system?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
What is meant by a Clique?
Describe the between keyword in teradata?