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
- 13069 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / siri
The Optimizer plans an execution strategy for every
SQL query submitted to it. We have also seen that the
execution strategy
for any query may be subject to change depending on various
factors. For
the Optimizer to consistently choose the optimum strategy,
it must be
provided with reliable, complete, and current demographic
information
regarding all of these factors. The best way to assure that
the Optimizer
has all the information it needs to generate optimum
execution strategies
is to COLLECT STATISTICS.
-Statistics tell the Optimizer how many rows/ value there
are.
– The Optimizer uses statistics to plan the best way to
access data.
– May improve performance of complex queries and joins.
– NUSI Bit Mapping requires collected statistics.
– Helpful in accessing a column or index with uneven value
distribution.
– Stale statistics may mislead the Optimizer into poor
decisions.
– Statistics remain valid across a reconfiguration of the
system.
– COLLECT is resource intensive and should be done during
off hours.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
How do you determine the number of sessions?
How do you create tables? Exact syntax, and create profiles, users in teradata?
Explain the term 'database' related to relational database management system?
How many codd's rules are satisfied by teradata database?
why use references rather than pointers in the public api, particularly for arguments which are modified?
Highlight a few of the advantages that ETL tools have over Teradata.
What is teradata?
How do you verify a complicated sql?
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 the difference between fastload and multiload? Which one is faster?
What is node? How many nodes and amps used in your previous project?
What is basic teradata query language?
Explain how spool space is used.
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
Explain the new features of teradata?
