Building with Amazon Aurora Databases

Languages Available: Español (Latinoamérica) | 日本語 | 한국어 | Português (Brasil) | 中文（简体)

In this lab, you will investigate how and when parallel query is applied to a statement. You will also learn how to ensure that parallel query is applied where it provides the most benefit.

Level

Intermediate

Duration

1 Hours 0 Minutes

Course objectives

In this course, you will learn how to:

      •    Understand how parallel query can benefit your workload

      •    Understand the benefit of parallel query for large datasets

      •    Determine some of the situations that trigger parallel query

Intended audience

This course is intended for:

      •    Solutions Architects

      •    Database Architects

      •    Developers

Prerequisites

We recommend that attendees of this course have the following prerequisites:

      •    Access to a notebook computer with Wi-Fi and Microsoft Windows, macOS X, or Linux (Ubuntu, SuSE, or Red Hat).

      •    Note: You can use an iPad or tablet device to access these directions in the lab console.

      •    An Internet browser such as Chrome, Firefox, or IE9+.

      •    Note: Previous versions of Internet Explorer are not supported.

      •    An SSH client such as PuTTY.

Course outline

Introduction

      •    Task 1: Explore the lab environment

      •    Task 2: Explore the data and parallel query settings

      •    Task 3: Understand the impact of parallel query

      •    Task 4: Understand how instance size impacts parallel query