Technical Articles
📄️ Types of Database Index
A database index is a data structure used to speed up database queries. It is similar to the catalog of books and can help quickly locate a certain row or rows in a table. A database index usually consists of a set of index keys (or index fields) whose values are stored in a data structure for fast lookup of specific rows.
📄️ Principles of Database Index Design
Indexes are one of the most important tools for optimizing database performance. However, creating too many indexes or indexing the wrong columns can also have a negative impact on performance. Therefore, it is important to follow certain principles when designing indexes.
📄️ Four Pitfalls of SQL Processing with Null Values
Channel of advanced SQL tuning
📄️ Node Type of Explain Tree
PostgreSQL
📄️ 9 Reasons to Avoid Using SELECT * and 2 Exceptional Cases
We often see articles warning that using SELECT is a bad habit and columns should be explicitly specified in queries, such as in the latest Alibaba Java Coding Guidelines (Taishan Edition) where it is a mandatory rule. However, people only have a vague understanding of the reasons behind avoiding SELECT . This article explains 9 reasons to avoid using SELECT from two perspectives, and also discusses two reasonable exceptional cases to use SELECT .
📄️ Optimize TPCH Queries with PawSQL
Overview
📄️ Plan Visualization for MySQL
Copyright © 2022 PawSQL