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
- 12881 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 is the difference between global temporary tables and volatile temporary tables?
How can we check the version of Teradata that we are using currently?
What do you mean by fastexport in teradata?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
What are the components used in smp and massively parallel processing (mpp) machines?
Highlight the limitations of TPUMP Utility.
Explain the term 'primary key' related to relational database management system?
Explain teradata vs. Redshift?
What is the purpose of joins in teradata?
When tpump is used instead of multiload?
How do you determine the number of sessions?
In Teradata, what is the significance of UPSERT command?
Can you fastexport a field, which is primary key by putting equality on that key?
What are the 5 phases in a multiload utility?
