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
Why does varchar occupy 2 extra bytes?
Explain the term 'primary key' related to relational database management system?
List the logical and conditional operators that are used with teradata along with their meanings?
What are the various indexes in teradata? How to use them?
How many sessions of MAX is PE capable of handling at a particular time?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
What is meant by a dispatcher?
What are the 5 phases in a multiload utility?
List out some of the primary characteristics of teradata.
What is the use of stored procedures in teradata?
Explain vproc in teradata?
What are the steps to create a data model?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What are the various indexes in teradata?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!