-
Database Indexing for Dumb Developers
This video explains what happens under the hood when indexing a database and explains why it can lead to performance benefits.
published: 12 Apr 2021
-
SQL indexing best practices | How to make your database FASTER!
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.
Try CockroachDB serverless (it's free): 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-s...
published: 20 Sep 2022
-
How do SQL Indexes Work
Database index tutorial | how database indexing actually works | how does index work in sql | how sql index works
Notes and Slides
https://www.pragimtech.com/blog/sql-optimization/how-do-sql-indexes-work/
SQL Server Tutorial for beginners
https://www.youtube.com/playlist?list=PL08903FB7ACA1C2FB
SQL Server Interview Questions and Answers
https://www.youtube.com/playlist?list=PL6n9fhu94yhXcztdLO7i6mdyaegC8CJwR
SQL Server Performance Tuning and Query Optimization
https://www.youtube.com/playlist?list=PL6n9fhu94yhXg5A0Fl3CQAo1PbOcRPjd0
published: 30 Mar 2021
-
Database Indexing Explained (with PostgreSQL)
Get my Fundamentals of Database Engineering udemy course to learn more , link redirects to udemy with coupon applied https://database.husseinnasser.com
This is a practical video on Database Indexing where I explain what is an index, why do we need it and how it can improve the performance of the queries. Also how (if used incorrectly) it can slow down your queries
intro 0:00
What is an index 0:30
Describe Table 2:15
SELECT [ID] WHERE ID 4:00
SELECT [NAME] WHERE ID 6:30
SELECT [ID] WHERE [NAME] (No index) 9:20
SELECT [ID] WHERE NAME LIKE 11:12
CREATE INDEX ON [NAME] 12:00
SELECT [ID] WHERE NAME (Indexed) 12:50
SELECT [1D] WHERE NAME LIKE (Indexed) 14:30
Summary 16:00
Support my work on PayPal
https://bit.ly/33ENps4
Become a Member on YouTube
https://www.youtube.com/channel/UC_...
published: 30 Sep 2020
-
Things Every Developer Absolutely, Positively Needs to Know About Database Indexing - Kai Sassnowski
Kai is an active member of the Laravel community and the author of several open source projects such as Laravel Venture and Roach, the complete web scraping toolkit for PHP.
This talk dives deep into a topic that I believe developers don't know enough about: database indexing. Nothing can kill application performance quite like slow database queries.
We will cover the data structure behind the most common type of index and how it affects the behaviour of an index. After that, we will take a look at the different ways a database can use an index to execute different queries. To do so, we also have to learn how to access and understand the execution plan for a given query.
📹 Recorded from the following event: https://www.meetup.com/laravel-switzerland-meetup/events/289543059/
🐦 Kai's Twit...
published: 15 Dec 2022
-
Don't hide your database indexes!
Using a redundant condition is a technique to allow MySQL to use an index where it might otherwise be impossible!
00:00 Intro
01:06 Redundant condition drawing
02:12 Obfuscated indexes in MySQL
03:04 Obfuscated index example
04:50 Redundant condition example
06:18 Explaining the ADDTIME query
07:18 Adding a redundant condition
08:59 A second example
10:41 When to use redundant conditions
📚 Learn more about PlanetScale at https://planetscale.com/youtube.
——————————————————
💬 Follow PlanetScale on social media
• Twitter: https://twitter.com/planetscaledata
• Discord: https://discord.gg/pDUGAAFEJx
• TikTok: https://www.tiktok.com/@planetscale
• Twitch: https://www.twitch.tv/planetscale
• LinkedIn: https://www.linkedin.com/company/planetscale/
published: 03 Jul 2023
-
Easy database indexing strategies
Functional indexes and generated columns are a way to index things that aren't traditionally indexable, like JSON columns, data normalizations, or calculations.
To learn more about PlanetScale, head to https://planetscale.com/youtube!
Case insensitive searching video: https://www.youtube.com/watch?v=ML24GRzXF9w
Generated hash indexes video: https://www.youtube.com/watch?v=5aezDBaNfcc
--------
00:00 Functional indexes and generated columns
00:45 What is a functional index?
02:11 Example 1: Indexing the end of a string
05:05 Example 2: Case sensitive indexing
07:37 Example 3: Indexing a TEXT or BLOB
09:54 Example 4: Indexing a date part
12:57 Example 4.5: Indexing a date part, semantically
16:25 Example 5: Grouping by functional index
19:08 Example 6: Calculating age
21:09 Example 7: Data...
published: 26 Oct 2023
-
MySQL: INDEXES are awesome
#mysql #tutorial #course
-- INDEX (BTree data structure)
-- Indexes are used to find values within a specific column more quickly
-- MySQL normally searches sequentially through a column
-- The longer the column, the more expensive the operation is
-- UPDATE takes more time, SELECT takes less time
-- Single column index
CREATE INDEX last_name_idx
ON customers (last_name);
-- Multi column index
CREATE INDEX last_name_first_name_idx
ON customers (last_name, first_name);
published: 11 Nov 2022
-
How do B-Tree Indexes work? | Systems Design Interview: 0 to 1 with Google Software Engineer
You throw your data in B-Trees, I throw my data in B-holes, we are not the same.
Sorry about the poor explanation of node splitting on writes, here's an extra reference video if you need it:
https://www.youtube.com/watch?v=C_q5ccN84C8&t=605s&ab_channel=FullstackAcademy.
Again, please don't comment that the size of the B-tree page is in kilobytes, I get it now.
published: 10 Jan 2023
-
Faster database indexes (straight from the docs)
Creating faster composite indexes via hashed columns! To learn more about PlanetScale, visit us at planetscale.com.
Link to the MySQL docs: https://dev.mysql.com/doc/refman/8.0/en/multiple-column-indexes.html
📚 Learn more about PlanetScale at https://planetscale.com/youtube.
——————————————————
00:00 MySQL documentation
00:58 Addresses table
02:17 Hash columns
04:13 concat vs concat_ws
05:40 Generated columns
07:31 The UNHEX function
09:34 Searching via hash
11:22 MD5 hash collisions
12:46 Functional indexes
——————————————————
💬 Follow PlanetScale on social media
• Twitter: https://twitter.com/planetscaledata
• Discord: https://discord.gg/pDUGAAFEJx
• TikTok: https://www.tiktok.com/@planetscale
• Twitch: https://www.twitch.tv/planetscale
• LinkedIn: https://www.linkedin.com/company/plan...
published: 29 Sep 2023
15:59
Database Indexing for Dumb Developers
This video explains what happens under the hood when indexing a database and explains why it can lead to performance benefits.
This video explains what happens under the hood when indexing a database and explains why it can lead to performance benefits.
https://wn.com/Database_Indexing_For_Dumb_Developers
This video explains what happens under the hood when indexing a database and explains why it can lead to performance benefits.
- published: 12 Apr 2021
- views: 71366
4:08
SQL indexing best practices | How to make your database FASTER!
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'...
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.
Try CockroachDB serverless (it's free): 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
https://wn.com/Sql_Indexing_Best_Practices_|_How_To_Make_Your_Database_Faster
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.
Try CockroachDB serverless (it's free): 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
- published: 20 Sep 2022
- views: 93340
12:12
How do SQL Indexes Work
Database index tutorial | how database indexing actually works | how does index work in sql | how sql index works
Notes and Slides
https://www.pragimtech.com/b...
Database index tutorial | how database indexing actually works | how does index work in sql | how sql index works
Notes and Slides
https://www.pragimtech.com/blog/sql-optimization/how-do-sql-indexes-work/
SQL Server Tutorial for beginners
https://www.youtube.com/playlist?list=PL08903FB7ACA1C2FB
SQL Server Interview Questions and Answers
https://www.youtube.com/playlist?list=PL6n9fhu94yhXcztdLO7i6mdyaegC8CJwR
SQL Server Performance Tuning and Query Optimization
https://www.youtube.com/playlist?list=PL6n9fhu94yhXg5A0Fl3CQAo1PbOcRPjd0
https://wn.com/How_Do_Sql_Indexes_Work
Database index tutorial | how database indexing actually works | how does index work in sql | how sql index works
Notes and Slides
https://www.pragimtech.com/blog/sql-optimization/how-do-sql-indexes-work/
SQL Server Tutorial for beginners
https://www.youtube.com/playlist?list=PL08903FB7ACA1C2FB
SQL Server Interview Questions and Answers
https://www.youtube.com/playlist?list=PL6n9fhu94yhXcztdLO7i6mdyaegC8CJwR
SQL Server Performance Tuning and Query Optimization
https://www.youtube.com/playlist?list=PL6n9fhu94yhXg5A0Fl3CQAo1PbOcRPjd0
- published: 30 Mar 2021
- views: 641464
18:19
Database Indexing Explained (with PostgreSQL)
Get my Fundamentals of Database Engineering udemy course to learn more , link redirects to udemy with coupon applied https://database.husseinnasser.com
This i...
Get my Fundamentals of Database Engineering udemy course to learn more , link redirects to udemy with coupon applied https://database.husseinnasser.com
This is a practical video on Database Indexing where I explain what is an index, why do we need it and how it can improve the performance of the queries. Also how (if used incorrectly) it can slow down your queries
intro 0:00
What is an index 0:30
Describe Table 2:15
SELECT [ID] WHERE ID 4:00
SELECT [NAME] WHERE ID 6:30
SELECT [ID] WHERE [NAME] (No index) 9:20
SELECT [ID] WHERE NAME LIKE 11:12
CREATE INDEX ON [NAME] 12:00
SELECT [ID] WHERE NAME (Indexed) 12:50
SELECT [1D] WHERE NAME LIKE (Indexed) 14:30
Summary 16:00
Support my work on PayPal
https://bit.ly/33ENps4
Become a Member on YouTube
https://www.youtube.com/channel/UC_ML5xP23TOWKUcc-oAE_Eg/join
🧑🏫 Courses I Teach
https://husseinnasser.com/courses
🏭 Backend Engineering Videos in Order
https://backend.husseinnasser.com
💾 Database Engineering Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQXjD0HOzN7P2tgzu7scWpl2
🏰 Load Balancing and Proxies Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQVMeBmWI2AhxULWEeo7AaMC
🏛️ Software Archtiecture Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQXNP6mQchJVP3S-3oKGEuw9
📩 Messaging Systems
https://www.youtube.com/playlist?list=PLQnljOFTspQVcumYRWE2w9kVxxIXy_AMo
Become a Member
https://www.youtube.com/channel/UC_ML5xP23TOWKUcc-oAE_Eg/join
Support me on PayPal
https://bit.ly/33ENps4
Stay Awesome,
Hussein
https://wn.com/Database_Indexing_Explained_(With_Postgresql)
Get my Fundamentals of Database Engineering udemy course to learn more , link redirects to udemy with coupon applied https://database.husseinnasser.com
This is a practical video on Database Indexing where I explain what is an index, why do we need it and how it can improve the performance of the queries. Also how (if used incorrectly) it can slow down your queries
intro 0:00
What is an index 0:30
Describe Table 2:15
SELECT [ID] WHERE ID 4:00
SELECT [NAME] WHERE ID 6:30
SELECT [ID] WHERE [NAME] (No index) 9:20
SELECT [ID] WHERE NAME LIKE 11:12
CREATE INDEX ON [NAME] 12:00
SELECT [ID] WHERE NAME (Indexed) 12:50
SELECT [1D] WHERE NAME LIKE (Indexed) 14:30
Summary 16:00
Support my work on PayPal
https://bit.ly/33ENps4
Become a Member on YouTube
https://www.youtube.com/channel/UC_ML5xP23TOWKUcc-oAE_Eg/join
🧑🏫 Courses I Teach
https://husseinnasser.com/courses
🏭 Backend Engineering Videos in Order
https://backend.husseinnasser.com
💾 Database Engineering Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQXjD0HOzN7P2tgzu7scWpl2
🏰 Load Balancing and Proxies Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQVMeBmWI2AhxULWEeo7AaMC
🏛️ Software Archtiecture Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQXNP6mQchJVP3S-3oKGEuw9
📩 Messaging Systems
https://www.youtube.com/playlist?list=PLQnljOFTspQVcumYRWE2w9kVxxIXy_AMo
Become a Member
https://www.youtube.com/channel/UC_ML5xP23TOWKUcc-oAE_Eg/join
Support me on PayPal
https://bit.ly/33ENps4
Stay Awesome,
Hussein
- published: 30 Sep 2020
- views: 317540
49:00
Things Every Developer Absolutely, Positively Needs to Know About Database Indexing - Kai Sassnowski
Kai is an active member of the Laravel community and the author of several open source projects such as Laravel Venture and Roach, the complete web scraping too...
Kai is an active member of the Laravel community and the author of several open source projects such as Laravel Venture and Roach, the complete web scraping toolkit for PHP.
This talk dives deep into a topic that I believe developers don't know enough about: database indexing. Nothing can kill application performance quite like slow database queries.
We will cover the data structure behind the most common type of index and how it affects the behaviour of an index. After that, we will take a look at the different ways a database can use an index to execute different queries. To do so, we also have to learn how to access and understand the execution plan for a given query.
📹 Recorded from the following event: https://www.meetup.com/laravel-switzerland-meetup/events/289543059/
🐦 Kai's Twitter: https://twitter.com/warsh33p
https://wn.com/Things_Every_Developer_Absolutely,_Positively_Needs_To_Know_About_Database_Indexing_Kai_Sassnowski
Kai is an active member of the Laravel community and the author of several open source projects such as Laravel Venture and Roach, the complete web scraping toolkit for PHP.
This talk dives deep into a topic that I believe developers don't know enough about: database indexing. Nothing can kill application performance quite like slow database queries.
We will cover the data structure behind the most common type of index and how it affects the behaviour of an index. After that, we will take a look at the different ways a database can use an index to execute different queries. To do so, we also have to learn how to access and understand the execution plan for a given query.
📹 Recorded from the following event: https://www.meetup.com/laravel-switzerland-meetup/events/289543059/
🐦 Kai's Twitter: https://twitter.com/warsh33p
- published: 15 Dec 2022
- views: 6044
11:35
Don't hide your database indexes!
Using a redundant condition is a technique to allow MySQL to use an index where it might otherwise be impossible!
00:00 Intro
01:06 Redundant condition drawing...
Using a redundant condition is a technique to allow MySQL to use an index where it might otherwise be impossible!
00:00 Intro
01:06 Redundant condition drawing
02:12 Obfuscated indexes in MySQL
03:04 Obfuscated index example
04:50 Redundant condition example
06:18 Explaining the ADDTIME query
07:18 Adding a redundant condition
08:59 A second example
10:41 When to use redundant conditions
📚 Learn more about PlanetScale at https://planetscale.com/youtube.
——————————————————
💬 Follow PlanetScale on social media
• Twitter: https://twitter.com/planetscaledata
• Discord: https://discord.gg/pDUGAAFEJx
• TikTok: https://www.tiktok.com/@planetscale
• Twitch: https://www.twitch.tv/planetscale
• LinkedIn: https://www.linkedin.com/company/planetscale/
https://wn.com/Don't_Hide_Your_Database_Indexes
Using a redundant condition is a technique to allow MySQL to use an index where it might otherwise be impossible!
00:00 Intro
01:06 Redundant condition drawing
02:12 Obfuscated indexes in MySQL
03:04 Obfuscated index example
04:50 Redundant condition example
06:18 Explaining the ADDTIME query
07:18 Adding a redundant condition
08:59 A second example
10:41 When to use redundant conditions
📚 Learn more about PlanetScale at https://planetscale.com/youtube.
——————————————————
💬 Follow PlanetScale on social media
• Twitter: https://twitter.com/planetscaledata
• Discord: https://discord.gg/pDUGAAFEJx
• TikTok: https://www.tiktok.com/@planetscale
• Twitch: https://www.twitch.tv/planetscale
• LinkedIn: https://www.linkedin.com/company/planetscale/
- published: 03 Jul 2023
- views: 12912
36:03
Easy database indexing strategies
Functional indexes and generated columns are a way to index things that aren't traditionally indexable, like JSON columns, data normalizations, or calculations....
Functional indexes and generated columns are a way to index things that aren't traditionally indexable, like JSON columns, data normalizations, or calculations.
To learn more about PlanetScale, head to https://planetscale.com/youtube!
Case insensitive searching video: https://www.youtube.com/watch?v=ML24GRzXF9w
Generated hash indexes video: https://www.youtube.com/watch?v=5aezDBaNfcc
--------
00:00 Functional indexes and generated columns
00:45 What is a functional index?
02:11 Example 1: Indexing the end of a string
05:05 Example 2: Case sensitive indexing
07:37 Example 3: Indexing a TEXT or BLOB
09:54 Example 4: Indexing a date part
12:57 Example 4.5: Indexing a date part, semantically
16:25 Example 5: Grouping by functional index
19:08 Example 6: Calculating age
21:09 Example 7: Data normalization
24:04 Example 8: Indexing a raw calculation
26:23 Example 9: Combining multiple statuses, and composite indexes
31:02 Example 10: Indexing JSON parts
--------
💬 Follow PlanetScale on social media
• Twitter: https://twitter.com/planetscale
• Discord: https://discord.gg/pDUGAAFEJx
• TikTok: https://www.tiktok.com/@planetscale
• Twitch: https://www.twitch.tv/planetscale
• LinkedIn: https://www.linkedin.com/company/planetscale
https://wn.com/Easy_Database_Indexing_Strategies
Functional indexes and generated columns are a way to index things that aren't traditionally indexable, like JSON columns, data normalizations, or calculations.
To learn more about PlanetScale, head to https://planetscale.com/youtube!
Case insensitive searching video: https://www.youtube.com/watch?v=ML24GRzXF9w
Generated hash indexes video: https://www.youtube.com/watch?v=5aezDBaNfcc
--------
00:00 Functional indexes and generated columns
00:45 What is a functional index?
02:11 Example 1: Indexing the end of a string
05:05 Example 2: Case sensitive indexing
07:37 Example 3: Indexing a TEXT or BLOB
09:54 Example 4: Indexing a date part
12:57 Example 4.5: Indexing a date part, semantically
16:25 Example 5: Grouping by functional index
19:08 Example 6: Calculating age
21:09 Example 7: Data normalization
24:04 Example 8: Indexing a raw calculation
26:23 Example 9: Combining multiple statuses, and composite indexes
31:02 Example 10: Indexing JSON parts
--------
💬 Follow PlanetScale on social media
• Twitter: https://twitter.com/planetscale
• Discord: https://discord.gg/pDUGAAFEJx
• TikTok: https://www.tiktok.com/@planetscale
• Twitch: https://www.twitch.tv/planetscale
• LinkedIn: https://www.linkedin.com/company/planetscale
- published: 26 Oct 2023
- views: 25712
6:26
MySQL: INDEXES are awesome
#mysql #tutorial #course
-- INDEX (BTree data structure)
-- Indexes are used to find values within a specific column more quickly
-- MySQL normally searches se...
#mysql #tutorial #course
-- INDEX (BTree data structure)
-- Indexes are used to find values within a specific column more quickly
-- MySQL normally searches sequentially through a column
-- The longer the column, the more expensive the operation is
-- UPDATE takes more time, SELECT takes less time
-- Single column index
CREATE INDEX last_name_idx
ON customers (last_name);
-- Multi column index
CREATE INDEX last_name_first_name_idx
ON customers (last_name, first_name);
https://wn.com/Mysql_Indexes_Are_Awesome
#mysql #tutorial #course
-- INDEX (BTree data structure)
-- Indexes are used to find values within a specific column more quickly
-- MySQL normally searches sequentially through a column
-- The longer the column, the more expensive the operation is
-- UPDATE takes more time, SELECT takes less time
-- Single column index
CREATE INDEX last_name_idx
ON customers (last_name);
-- Multi column index
CREATE INDEX last_name_first_name_idx
ON customers (last_name, first_name);
- published: 11 Nov 2022
- views: 57976
9:12
How do B-Tree Indexes work? | Systems Design Interview: 0 to 1 with Google Software Engineer
You throw your data in B-Trees, I throw my data in B-holes, we are not the same.
Sorry about the poor explanation of node splitting on writes, here's an extra ...
You throw your data in B-Trees, I throw my data in B-holes, we are not the same.
Sorry about the poor explanation of node splitting on writes, here's an extra reference video if you need it:
https://www.youtube.com/watch?v=C_q5ccN84C8&t=605s&ab_channel=FullstackAcademy.
Again, please don't comment that the size of the B-tree page is in kilobytes, I get it now.
https://wn.com/How_Do_B_Tree_Indexes_Work_|_Systems_Design_Interview_0_To_1_With_Google_Software_Engineer
You throw your data in B-Trees, I throw my data in B-holes, we are not the same.
Sorry about the poor explanation of node splitting on writes, here's an extra reference video if you need it:
https://www.youtube.com/watch?v=C_q5ccN84C8&t=605s&ab_channel=FullstackAcademy.
Again, please don't comment that the size of the B-tree page is in kilobytes, I get it now.
- published: 10 Jan 2023
- views: 19920
13:28
Faster database indexes (straight from the docs)
Creating faster composite indexes via hashed columns! To learn more about PlanetScale, visit us at planetscale.com.
Link to the MySQL docs: https://dev.mysql.c...
Creating faster composite indexes via hashed columns! To learn more about PlanetScale, visit us at planetscale.com.
Link to the MySQL docs: https://dev.mysql.com/doc/refman/8.0/en/multiple-column-indexes.html
📚 Learn more about PlanetScale at https://planetscale.com/youtube.
——————————————————
00:00 MySQL documentation
00:58 Addresses table
02:17 Hash columns
04:13 concat vs concat_ws
05:40 Generated columns
07:31 The UNHEX function
09:34 Searching via hash
11:22 MD5 hash collisions
12:46 Functional indexes
——————————————————
💬 Follow PlanetScale on social media
• Twitter: https://twitter.com/planetscaledata
• Discord: https://discord.gg/pDUGAAFEJx
• TikTok: https://www.tiktok.com/@planetscale
• Twitch: https://www.twitch.tv/planetscale
• LinkedIn: https://www.linkedin.com/company/planetscale/
https://wn.com/Faster_Database_Indexes_(Straight_From_The_Docs)
Creating faster composite indexes via hashed columns! To learn more about PlanetScale, visit us at planetscale.com.
Link to the MySQL docs: https://dev.mysql.com/doc/refman/8.0/en/multiple-column-indexes.html
📚 Learn more about PlanetScale at https://planetscale.com/youtube.
——————————————————
00:00 MySQL documentation
00:58 Addresses table
02:17 Hash columns
04:13 concat vs concat_ws
05:40 Generated columns
07:31 The UNHEX function
09:34 Searching via hash
11:22 MD5 hash collisions
12:46 Functional indexes
——————————————————
💬 Follow PlanetScale on social media
• Twitter: https://twitter.com/planetscaledata
• Discord: https://discord.gg/pDUGAAFEJx
• TikTok: https://www.tiktok.com/@planetscale
• Twitch: https://www.twitch.tv/planetscale
• LinkedIn: https://www.linkedin.com/company/planetscale/
- published: 29 Sep 2023
- views: 127551