Question
When is the update_statistics command used?
Answers
When the processing of large data is done, this command is used.
Whenever large number of deletions, modification or copy takes place into the tables, the indexes need to be updated to take care of these changes. UPDATE_STATISTICS performs this job.   Your Comment




  • Contributors: *,
More Software Questions..
What is the inputsplit in map reduce software?
What is software configuration management?
What Is Java Api For Xml-based Rpc (jax-rpc)?
How can you implement fine-grained auditing?
What is IBM’s simple explanation for Big Data’s four critical features?
What is static synchronized method in JDBC API? Give an example?
What does the NULLIF function do?
What happens if a start method is not invoked and the run method is directly invoked?
Should we override finalize method
what is the difference between mysql_fetch_array and mysql_fetch_object?
How will XML affect my document links?
Why to use Style Sheets?
What are Filters in MVC?
Can you explain Application layer in OSI model?
How to define new testplan attributes?
What are the minimum system requirements to run Photoshop? Is it possible to run Photoshop over linux?
Which oracle package is used to manage the oracle lock management services?
What is Latch Up? Explain Latch Up with cross section of a CMOS Inverter. How do you avoid Latch Up?
What is marker interface?
What types of partitioning are there for BW?


Search
Can you Answer!!
  • Q What is an offset-list, and how is it useful?
  • Q What is an EXTERNAL QUERY ?
  • Q Write Short Notes on Enrichment media
  • Q What type of animal is a caribou?
  • Q Bajirao I (1720-1740 AD) was the ruler of which dynasty?
  • Q Explain what will be the responsibility of the spacecraft operations,dynamics and controls?
  • Q While creating the multidimensional arrays, can you specify an array dimension after an empty dimension?
  • Q How to display the check box in data grid header?
  • Q Mention the difference between data mining and machine learning?
  • Q To increase the input resistance in differential amplifier, replace the transistor by?
  • Q The lack of Oxygen in the tissues: