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
