Optimising Redshift DataWarehouse using DIST and SORT Key

In this video, we go over the concept of DISTKEY and SORTKEY. If you're a MySQL or PostgreSQL user who is used to indexes, these two Redshift concepts might seem a bit strange.

Redshift's DISTKEY and SORTKEY are powerful tools that are easy to use. By using these options, you can avoid issues that can be caused by Redshift's compression. Such issues include slow queries, wrong results, missing results, and more.

In fact, the way Redshift uses them, you'll probably never have a need for a fully-fledged index. Indexes are great, but they have a cost, so it's important to understand when indexes are appropriate for your workload.

In this video, we go over the basics of DISTKEY and SORTKEY by looking at a basic example.

Dataset used in the video - https://docs.aws.amazon.com/redshift/...
Redshift Whitepaper - https://docs.aws.amazon.com/whitepape...

I have also created playlists for the data engineering roadmap and projects

Data Engineering Complete Roadmap -    • Data Engineer Complete Road Map 2022  

Data Engineering Project Series -    • Data Engineering Project Portfolio  

Also, you can
Join Discord Channel -   / discord  

===================Follow Me Here===================
👦🏻 My Linkedin -   / darshil-parmar  
📷 Instagram -   / darshilparmarr  
🎯Twitter -   / parmardarshil07  

===================About Me===================
Freelance Data Engineer and Solution Architect.
I love learning about technology and teaching thing I know to other people. The goal of creating this channel was to teach everything I know to the world, I have spent most of my time learning things online and I want to share all my learning on this youtube channel.
I will be posting content related to data engineering, architecting systems, data science, machine learning, and interview preparation.


Thank you for watching the video, see you in the next video :)

My Accessories
🎙 Mic -https://amzn.to/3Bnu53n
📱 Camera (I use my phone) - https://amzn.to/3wOogIU
🎧 Headphone - https://amzn.to/3BsJxLB
⌨ Mouse and Keyboard - https://amzn.to/3zeF1yq
🖥 Monitor - https://amzn.to/3zk0Dts