Answered: What are the database statistics…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

100%

What are the database statistics measurement typical of indexes?

What are the database statistics measurement typical of resources?

Expert Solution

Step 1

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.

Step by step

Solved in 2 steps

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions