From the course: Oracle HeatWave MySQL Foundations

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Practice 4-3: Optimizing string column encoding with Auto Encoding Advisor

Practice 4-3: Optimizing string column encoding with Auto Encoding Advisor

From the course: Oracle HeatWave MySQL Foundations

Start my 1-month free trial Buy for my team

Practice 4-3: Optimizing string column encoding with Auto Encoding Advisor

“

(gentle music) - Welcome to practice 4-3, optimizing stream column encoding with Auto Encoding Advisor. We're going to assume that you've successfully completed all of the previous practices, and that you're signed in to an Oracle Cloud Infrastructure account that's been configured for this course. To start, you'll need to be in CloudShell, which is located under developer tools. Maximize for easier viewing, and confirm your network details. You should be in an ephemeral network with a MDSVCNPRV subnet. If this isn't true for you, refer to the previous practices to how to connect to this network. Now, we'll need to connect to the MySQL database system. Log in with your administrator credentials. We'll also want to set our default database to be AirportDB. Now, let's go ahead and invoke the Auto Encoding Advisor using a call statement. From these details here, I can see that I have a total of five tables available to me with 25 columns. From the output, I can see that the airline…

Contents