SGShreyansh Guptainshreyanshgupta.hashnode.dev·Dec 14, 2024 · 4 min readSQL Performance Explained by Markus WinandChapter 1: Anatomy of an index A lookup can be slow even with an index. An example of this is the Index Range Scan. In this, the database reads a large part of the index. If the table is accessed to lookup the rows that are read from the index, even ...00
SGShreyansh Guptainshreyanshgupta.hashnode.dev·Nov 29, 2024 · 6 min readExample for optimizing queriesHere, we’ll take a look at some examples of optimizing queries using indexes. MD5 Problem - How to use an MD5 column to do an indexed search when we might not be able to use index otherwise? Note that the big columns, such as text, are stored in a se...00
SGShreyansh Guptainshreyanshgupta.hashnode.dev·Nov 29, 2024 · 10 min readHow to write efficient queries in MySQLIntroduction to queries We are going to talk about actually accessing the data / querying the data efficiently. EXPLAIN overview We’ll try to understand the output of the EXPLAIN command. id - Shows the ID of the row in the output. Can be NULL. se...00
SGShreyansh Guptainshreyanshgupta.hashnode.dev·Nov 24, 2024 · 9 min readIndexes in MySQLWhat is an index? An index is a - A separate data structure - It is separate from the actual table. A copy of (part of) our data - Whenever we add an index to any column or columns in a table, it copies a part of the data into the index table. Point...00
SGShreyansh Guptainshreyanshgupta.hashnode.dev·Nov 20, 2024 · 8 min readData types in MySQLIn this article, we are going to take a look at the different data types in MySQL databases. First of all let's take a look at our goals while designing schema. We want our schema to be - Small - e.g. don't use a BIGINT when a TINYINT would do. Sim...00
