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 is a node in teradata?
What are aggregate tables? How do you design them using teradata?
What is the difference between global temporary tables and volatile temporary tables?
What is meant by a Highest Cost Plan?
Is multi insert ansi standard?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
how many modules are there in telecome domain?how to explain the architecture?
Highlight the advantages of PPI(Partition Primary Index).
How many tables can you join in v2r5?
What is meant by a Parsing Engine?
What is bteq script in teradata?
What do you mean by tpt in teradata?
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 is meant by a node?