Nothing here yet.
Nothing here yet.
Dec 14, 2024 · 4 min read · Chapter 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 ...
Join discussion
Nov 29, 2024 · 6 min read · Here, 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...
Join discussion
Nov 29, 2024 · 10 min read · Introduction 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...
Join discussion
Nov 24, 2024 · 9 min read · What 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...
Join discussion
Nov 20, 2024 · 8 min read · In 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...
Join discussion