BuyFindarrow_forward

Database Systems: Design, Implemen...

12th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781305627482

Solutions

Chapter
Section
BuyFindarrow_forward

Database Systems: Design, Implemen...

12th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781305627482
Chapter 11, Problem 5RQ
Textbook Problem
312 views

How are database statistics obtained?

Program Plan Intro

Database statistics:

Database statistics is about gathering measurement number about the database objects.

  • The objects of the database include tables, indexes, number of processor used, speed of the processor and spaces that are available temporary are being measured for the resources.
  • Gathering this type of information in the form of statistics can provide a clear portrait about the characteristics of the DBMS.
  • Gathering database statistics plays a major role in the query optimization.
  • Gathering database statistics is important because they are used in obtaining the critical decision in improving the efficiency of the query processing.

Explanation of Solution

Obtaining statistics of database:

  • The statistics of the database can be gathered in two ways:
    • Gathering information manually using Database Administrator.
    • Gathering information automatically using DBMS (Database Management System).
  • Newer DBMS gather statistics automatically; newer DBMS such as Oracle, MySQL, SQL Server and DB2.
  • Some of the methods of obtaining statistics manually include:
    • Use of SQL’s ANALYZE command to gather statistics.
    • Use of RUNSTATS procedure of IBM’s DB2...

Still sussing out bartleby?

Check out a sample textbook solution.

See a sample solution

The Solution to Your Study Problems

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

Get Started

Additional Engineering Textbook Solutions

Find more solutions based on key concepts
Show solutions add
Describe the role of a CIO within an organization.

Principles of Information Systems (MindTap Course List)

Never operate machinery without proper ______ in place.

Precision Machining Technology (MindTap Course List)

What does the relative magnitude of second moment of area represent?

Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)

What is a system requirement, and how are system requirements classified?

Systems Analysis and Design (Shelly Cashman Series) (MindTap Course List)

Check the adequacy of the bolts. The given load is a service load. a. Use LRFD. b. Use ASD.

Steel Design (Activate Learning with these NEW titles from Engineering!)

Describe the purpose of these mobile devices: digital cameras, portable and digital media players, e-book reade...

Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)

If your motherboard supports ECC DDR3 memory, can you substitute non-ECC DDR3 memory?

A+ Guide to Hardware (Standalone Book) (MindTap Course List)