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
- 12815 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
Describe the between keyword in teradata?
any one answer me how they can analyzing the project using data ware housing?
Explain and compare pros and cons of start schemas?
Highlight a few of the advantages that ETL tools have over Teradata.
What is the difference between global temporary tables and volatile temporary tables?
Define views in teradata with general syntax.
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
What is a dimension table?
What is the use of fallback?
What do you mean by caching in teradata?
What is the use of having index on table?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
What is the purpose of joins in teradata and what are the available join types?
Highlight all the modes that are present under Confidence Level.
List out all forms of LOCKS that are available in Teradata.
