10 min listen
Table Clustering (Clustered Index) - The pros and cons
Table Clustering (Clustered Index) - The pros and cons
ratings:
Length:
29 minutes
Released:
Aug 20, 2021
Format:
Podcast episode
Description
In this episode of the backend engineering show, I discuss database clustering. This is also known as table clustering, clustered index or Index organized table all names represents the same thing. I will talk about the benefits of clustering and also the disadvantages of implementing clustering. This feature is also implicitly implemented in certain databases.
More readings
https://www.postgresql.org/docs/14/sql-cluster.html
https://oracle-base.com/articles/8i/index-organized-tables
https://docs.microsoft.com/en-us/sql/relational-databases/indexes/clustered-and-nonclustered-indexes-described?view=sql-server-ver15
https://dev.mysql.com/doc/refman/5.7/en/innodb-index-types.html
Become a Member on YouTube
https://www.youtube.com/channel/UC_ML5xP23TOWKUcc-oAE_Eg/join
? Members Only Content
https://www.youtube.com/playlist?list=UUMO_ML5xP23TOWKUcc-oAE_Eg
Support my work on PayPal
https://bit.ly/33ENps4
?? 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
?️Listen to the Backend Engineering Podcast
https://husseinnasser.com/podcast
More readings
https://www.postgresql.org/docs/14/sql-cluster.html
https://oracle-base.com/articles/8i/index-organized-tables
https://docs.microsoft.com/en-us/sql/relational-databases/indexes/clustered-and-nonclustered-indexes-described?view=sql-server-ver15
https://dev.mysql.com/doc/refman/5.7/en/innodb-index-types.html
Become a Member on YouTube
https://www.youtube.com/channel/UC_ML5xP23TOWKUcc-oAE_Eg/join
? Members Only Content
https://www.youtube.com/playlist?list=UUMO_ML5xP23TOWKUcc-oAE_Eg
Support my work on PayPal
https://bit.ly/33ENps4
?? 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
?️Listen to the Backend Engineering Podcast
https://husseinnasser.com/podcast
Released:
Aug 20, 2021
Format:
Podcast episode
Titles in the series (100)
Episode 09 - Advice to new Software Engineers by The Backend Engineering Show with Hussein Nasser