Table Clustering (Clustered Index) - The pros and cons

The Backend Engineering Show with Hussein Nasser

Episode | Podcast

Date: Fri, 20 Aug 2021 06:00:00 GMT

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