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 7P
Textbook Problem
118 views

Problems 7–32 are based on the ER model shown in Figure P11.7. Problems 7-10 are based on the following query:

SELECT P_CODE, P_PRICE
FROM PRODUCT
WHERE P_PRICE >= (SELECT AVG(P_PRICE) FROM PRODUCT);

Assuming there are no table statistics, what type of optimization will the DBMS use?

Program Plan Intro

Optimization:

The main purpose of the optimizer is finding an alternative choice of executing the query based on the evaluation of cost and apply that is with the lowest cost.

  • It is a process that takes place centrally during the parsing phase of query processing.

Optimization of the query can take place in two forms namely:

  • Rule based optimizer.
    • It determines the best approach to execute the query by utilizing preset rules.
    • Based on the rule, fixed cost is assigned for each of the SQL operation.
    • The costs are finally added to obtain the cost of the execution plan.
  • Cost based optimizer
    • It determines the best approach to execute the query by the use of sophisticated algorithm.
    • A statistics about the objects that are being accessed are obtained.
    • To determine the total cost of the given execution plan, processing costs, I/O costs and resource costs are being summed up.

Explanation of Solution

Type of optimization that DBMS uses for the given query:

The optimization type, the DBMS uses for the giv...

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

Chapter 11 Solutions

Database Systems: Design, Implementation, & Management
Show all chapter solutions
add
Ch. 11 - What are optimizer hints, and how are they used?Ch. 11 - What are some general guidelines for creating and...Ch. 11 - Most query optimization techniques are designed to...Ch. 11 - What recommendations would you make for managing...Ch. 11 - What does RAID stand for, and what are some...Ch. 11 - SELECT EMP_LNAME, EMP_FNAME, EMP_AREACODE, EMP_SEX...Ch. 11 - Problem 1 and 2 are based on the following query:...Ch. 11 - Using Table 11.4 as an example, create two...Ch. 11 - Problems 46 are based on the following query:...Ch. 11 - Problems 46 are based on the following query:...Ch. 11 - Problems 46 are based on the following query:...Ch. 11 - Problems 732 are based on the ER model shown in...Ch. 11 - Problems 732 are based on the ER model shown in...Ch. 11 - Problems 732 are based on the ER model shown in...Ch. 11 - Problems 732 are based on the ER model shown in...Ch. 11 - Problems 1114 are based on the following query:...Ch. 11 - Problems 1114 are based on the following query:...Ch. 11 - Problems 1114 are based on the following query:...Ch. 11 - Problems 1114 are based on the following query:...Ch. 11 - Problems 15 and 16 are based on the following...Ch. 11 - Problems 15 and 16 are based on the following...Ch. 11 - Problems 1721 are based on the following query:...Ch. 11 - Problems 1721 are based on the following query:...Ch. 11 - Problems 1721 are based on the following query:...Ch. 11 - Problems 1721 are based on the following query:...Ch. 11 - Problems 1721 are based on the following query:...Ch. 11 - SELECT P_CODE, P_DESCRIPT, P_PRICE, P.V_CODE,...Ch. 11 - Problems 2224 are based on the following query:...Ch. 11 - Problems 2224 are based on the following query:...Ch. 11 - Problems 25 and 26 are based on the following...Ch. 11 - Problems 25 and 26 are based on the following...Ch. 11 - Problems 27 and 28 are based on the following...Ch. 11 - Problems 27 and 28 are based on the following...Ch. 11 - Problems 2932 are based on the following query:...Ch. 11 - Problems 2932 are based on the following query:...Ch. 11 - Problems 2932 are based on the following query:...Ch. 11 - Problems 2932 are based on the following query:...

Additional Engineering Textbook Solutions

Find more solutions based on key concepts
Show solutions add
What is a table, and what role does it play in the relational model?

Database Systems: Design, Implementation, & Management

Why do many organizations ban port scanning activities on their internal networks?

Principles of Information Security (MindTap Course List)

Obtain information about K-, E-, and R-type thermocouple wires. Write a brief report discussing their accuracy,...

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

What is represented by the E, I, and R in the formula E = IR?

Automotive Technology: A Systems Approach (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)

What steps might you include in a backup plan?

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

State the advantages of having two oxygen regulators on a machine cutting torch.

Welding: Principles and Applications (MindTap Course List)