SQL
Database Search Performance Optimization: From SQL LIKE, MSSQL Full-Text Search to Elasticsearch
October 7, 2025
Program
In-depth exploration of database search performance optimization, comparing the pros and cons of SQL LIKE, MSSQL Full-Text Search, and Elasticsearch with implementation details.
Using CTE (Common Table Expression) to achieve lazy loading and querying infinite hierarchical data structure
July 25, 2023
Program
Recording the backend implementation of Lazy loading querying infinite hierarchical data structure.
Database Query Performance Optimization Tips : Index Concepts, Clustered, Non-Clustered
June 13, 2023
Program
Recording tips for optimizing query performance through indexing, differences between clustered and non-clustered indexes.
Database Query Performance Optimization Tips : Statement Optimization, Adding Indexes
March 29, 2023
Program
As the system data grows increasingly large, it's common to encounter situations where database queries take too long. This article provides several methods for optimizing database query performance.
SQL SCOPE_IDENTITY() and @@IDENTITY Differences in Retrieving Auto-Increment Values
March 20, 2023
Program
Retrieve the Most Recently Added Data in SQL