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
How do you do backup and recovery in teradata?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
how can we analyze the locks ?
Mention a few of the ETL tools that come under Teradata.
Explain fallback in teradata?
How is MLOAD Teradata Server restarted after execution?
Difference between inner join and outer join?
What is bteq script in teradata?
Which is faster fastload or multiload?
What do you mean by caching in teradata?
Different phases of multiload?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What are the steps involved after the disk manager passes the request?
What are the various indexes in teradata? How to use them?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?