Tag: SQL Performance Enhancement

Problem description In SQL Performance Enhancement: Queries on Highly Concurrent Accounts (hereinafter referred to as the previous article), we have discussed highly concurrent queries on single tables. Sometimes the query may also involve associative operations when the situation is complex. For example, when querying accounts, the detail data should be associated with the store table and other dimension tables, and the final result should include the fields of dimension tables, such as store name, address, phone number, etc. The data structure is as follows: The SQL statement is: To speed up the query response, we generally index the account id field of the “detail” table as

The essay analyzes the fundamental reason behind slow SQL statements and provides the solution to make improvements through code samples. Click SQL Performance Enhancement: Queries on Highly Concurrent Accounts for details.

The essay analyzes the fundamental reason behind slow SQL statements and provides the solution to make improvements through code samples. Click SQL Performance Enhancement: Binary Flag for details.

The essay analyzes the fundamental reason behind slow SQL statements and provides the solution to make improvements through code samples. Click SQL Performance Enhancement: Conversion Funnel Analysis for details.

The essay analyzes the fundamental reason behind slow SQL statements and provides the solution to make improvements through code samples. Click SQL Performance Enhancement: Count N Earliest Events in each Group for details.