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
- 12940 Views
- TCS, I also Faced
- E-Mail Answers
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 uses of fact table and dimension table in banking project?
Explain the most common data types used in teradata?
How do you create tables? Exact syntax, and create profiles, users in teradata?
What are the different functions performed in development phase?
What is meant by a Channel Driver?
What is difference between user and database in teradata?
What's the difference between timestamp (0) and timestamp (6)?
How you will check the version of teradata?
How does hashing happens in teradata?
What is stored procedure in teradata?
What is oltp?
How is the teradata different from oracle?
What is the purpose of joins in teradata and what are the available join types?
List out all forms of LOCKS that are available in Teradata.
What are the commands to make a new table, change a table and remove a table in teradata?
