menu
bartleby
search
close search
Hit Return to see all results
close solutoin list

Problems 17–21 are based on the following query: SELECT V_CODE, V_NAME, V_CONTACT, V_STATE FROM VENDOR WHERE V_STATE = 'TN' ORDER BY V_NAME; Using Table 11.4 as an example, create two alternative access plans. TABLE P11.18 STATE NUMBER OF VENDORS AK 15 AL 55 AZ 100 CA 3244 CO 345 FL 995 GA 75 HI 68 IL 89 IN 12 KS 19 KY 45 LA 29 MD 208 MI 745 MO 35 MS 47 NC 358 NH 25 NJ 645 NV 16 OH 821 OK 62 PA 425 RI 12 SC 65 SD 74 TN 113 TX 589 UT 36 VA 375 WA 258

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

Problems 17–21 are based on the following query:

SELECT V_CODE, V_NAME, V_CONTACT, V_STATE
FROM VENDOR
WHERE V_STATE = 'TN'
ORDER BY V_NAME;

Using Table 11.4 as an example, create two alternative access plans.

TABLE P11.18

STATE NUMBER OF VENDORS
AK 15
AL 55
AZ 100
CA 3244
CO 345
FL 995
GA 75
HI 68
IL 89
IN 12
KS 19
KY 45
LA 29
MD 208
MI 745
MO 35
MS 47
NC 358
NH 25
NJ 645
NV 16
OH 821
OK 62
PA 425
RI 12
SC 65
SD 74
TN 113
TX 589
UT 36
VA 375
WA 258

Explanation of Solution

Creating two alternative access plans with the data that are provided:

The below table shows the two alternative access plans for the data that are provided:

Given:

Total vendors: 10,000

Number of vendors in the cityTN : 113

Assumption:

Considering there are no indexes and reading each row will have I/O cost of “1”.

Table creation:

Plan Step Operations I/O operations I/O cost Resulting row sets Total I/O cost
A A1

Performs full table scan on the table VENDOR.

Select rows with V_STATE= “TN”

10,000 10,000 113 10,000
A2 Perform SORT operations and select rows that matches the given criteria.(V_STATE). 113 113 113 10,113
B B1

Performs Index scan for the given area code. (VEN_MYNDX1).

Select rows based on the state...

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
List and describe the different types of databases.

Database Systems: Design, Implementation, & Management

What is PPE?

Precision Machining Technology (MindTap Course List)

For Problems 16.44 through 16.48, discuss how you would create the solid model of the given objects. See Exampl...

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

What will Iris have on her to-do list?

Management Of Information Security

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

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

Explain the capabilities of administrator and user accounts on a network.

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