# 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

### Database Systems: Design, Implemen...

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

Chapter
Section

### 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

Find more solutions based on key concepts
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)