I’m a couple of months into working with MySQL, and thought I’d share some resources and thoughts on what I’m learning and what is working. At least half of that time was dedicated to a very in-depth onboarding process that barely mentioned a database at all in about a month of content, so it’s closer to a month in.… Read the restContinue reading »
Many RDBMSes have similar structures and concepts. In this post, I’m going to compare and contrast IBM Db2’s concept of a clustered index and MySQL’s concept of a clustered index.
Index vs. Clustered Index
An index is generally a way of organizing data in a way that it will be quicker to access than scanning through all of a table.… Read the restContinue reading »