Question: Login as system. Switch to SAMPLESCDB container (see troubleshooting tips linked under help section on d2l) Study the structure of OE.CUSTOMERS table. This table is

  1. Login as system. Switch to SAMPLESCDB container (see troubleshooting tips linked under help section on d2l)

  2. Study the structure of OE.CUSTOMERS table. This table is part of the same sample schema as OE.CUSTOMERS

What query did you use? Provide code of the query and screenshot of the results.

  1. Find all indexes on OE.CUSTOMERS table. You might need to use several data dictionary views to find all information required.

Provide code of all queries and screenshots of the results.

Index name

Column Name

Index Type

  1. Find how many rows in OE.CUSTOMERS table have information about customers whose last name contains "der".

What query did you use? Provide code of the query and screenshot of the results.

  1. Find an execution plan for the previous query. Pin the execution plan.

Provide a screenshot and an explanation of the observed results.

  1. Add index to OE.CUSTOMERS table. The index should combine customers' first name and last name.

What query did you use? Provide code of the query and screenshot of the results.

  1. Find how many rows in OE.CUSTOMERS table have information about customers whose last name contains "der".

What query did you use? Provide code of the query and screenshot of the results.

  1. Find an execution plan for the previous query.

Provide a screenshot and an explanation of the observed results.

  1. Compare execution plans for both queries (before and after the index).

Provide a screenshot and an explanation of observed results.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Objectives Compare different queries using EXPLAIN PLAN Login as system. Switch to pdborlc container (see troubleshooting tips linked under help section on d21) Study the structure of SHCUSTOMERS...

Q:

Just Need the SQL Statements: Login as system. Switch to orlcpdb container Study the structure of SH.CUSTOMERS table. This table is part of the same sample schema as OE.CUSTOMERS What query did you...

Q:

IfyouhaveplayedaSimulationcalledProBankerIneedhelpansweringthesequestionsassoonaspossible from the pro bankerassignment attachment..please use spreadsheet and players manual for reference. Need...

Q:

Can you please help me with this case problem? AICPA Case Development Program. Case No. 2000-02: Recreation, Inc Case No. 2000-02: Recreation, Inc. 1 AICPA Case Development Program RECREATION, INC....

Q:

He want us to identify the 18 vulnerabilities. template is attach. Case No. 2000-02: Recreation, Inc. 1 AICPA Case Development Program RECREATION, INC. AN INFORMATION TECHNOLOGY RISK ASSESSMENT CASE...

Q:

Risk Assestment Project - Identify 18 Vulnerabilit AICPA Case Development Program Case No. 2000-02: Recreation, Inc. ? 1 RECREATION, INC. AN INFORMATION TECHNOLOGY RISK ASSESSMENT CASE STUDY OF...

Q:

haa23684_PlugInT6CD.qxd 9/6/06 5:38 PM Page 2 CONFIRMING PAGES P L U G - I N T6 Basic Skills and Tools Using Access LEARNING OUTCOMES 1. Describe the primary functions using Microsoft Access. 2....

Q:

CHAPTER 9 Hypothesis Tests CONTENTS 9.4 POPULATION MEAN: UNKNOWN One-Tailed Test Two-Tailed Test Summary and Practical Advice 9.5 POPULATION PROPORTION Summary 9.6 HYPOTHESIS TESTING AND DECISION...

Q:

Decide if the speech adjustments below are about dialect or register differences. I say when I'm in Mexico, but when I'm in Argentina. I say when my friends tell me an incredible story, but if a...

Q:

DQ1 ? Why do companies outsource? What do they hope to achieve? What pitfalls must they avoid? DQ2 ? What does the literature indicate about the relative complexities and advantages of outsourcing...

Q:

(a) What is the eccentricity of a conic section? (b) What can you say about the eccentricity if the conic section is an ellipse? A hyperbola? A parabola? (c) Write a polar equation for a conic...

Q:

Smart Products buys 300,000 units of a crucial input per year from a supplier that fulfills its orders within two days of receiving them. Smart Products submits its orders directly to the supplier...

Q:

4. Question 4 A donor promised to pay $1 million to Oscarville charity for funding the headquarters, with a stipulation of receiving quarterly reports on the financial position. How should this be...

Q:

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Q:

Go to the website of the Federal Reserve Bank of St. Louis (http://www.stlouisfed.org) to find some information about the Fed. Find a map of the Federal Reserve districts. If you live in the United...

Q:

Suppose that the T-account for First National Bank is as follows: Assets Liabilities Reserves $100,000 Deposits $500,000 Loans 400,000 a. If the Fed requires banks to hold 5 percent of deposits as...

Q:

Imagine that you intend to buy a portfolio of ten stocks with some of your savings. Should the stocks be of companies in the same industry? Should the stocks be of companies located in the same...