MP3JOSS

SQL indexing best practices | How to make your database FASTER!

SQL indexing best practices | How to make your database FASTER!

Choose Download Format

Download MP3 Download MP4

Details

TitleSQL indexing best practices | How to make your database FASTER!
AuthorCockroachDB
Duration4:08
File FormatMP3 / MP4
Original URL https://youtube.com/watch?v=BIlFTFrEFOI

Description

Learn about best practices for using indexes in SQL, and how they can be used to speed up your queries, make your database faster, and improve your application's performance.

Get started with CockroachDB: https://cockroachlabs.cloud/signup

0:00 Intro
0:05 Example database table
0:15 Example query
0:21 The problem with a full table scan
0:50 Using EXPLAIN ANALYZE
1:04 What is a SQL index?
1:17 How to create a single-column index
1:37 How to create a multi-column index
2:08 Optimizing our SQL query
2:31 Caveats of sql indexes

Blog: https://www.cockroachlabs.com/blog/sql-performance-best-practices/
Docs: https://www.cockroachlabs.com/docs/stable/performance-best-practices-overview.html
Free Course: https://university.cockroachlabs.com/courses/course-v1:crl+getting-started-with-sql-for-app-devs+self-paced/about
Livestream | Making your queries FAST! https://www.youtube.com/live/Tcn5D4L9tJo

🎧 Just For You

🎵 Sorry Im Here For Someone Else - Benson… 🎵 Bundy Vision - Media Puzzle 🎵 Irl - Lizzo & Sza 🎵 Roar - Katy Perry 🎵 Old Town Road - Lil Nas X Feat. Billy Ray… 🎵 Sapphire - Ed Sheeran 🎵 4X4 - Travis Scott 🎵 Happy - Pharrell Williams 🎵 Daisies - Justin Bieber 🎵 Dior - Mk & Chrystal 🎵 Headphones On - Addison Rae 🎵 Just Keep Watching - Tate Mcrae