当前位置：网站首页>Methods of database query optimization

Methods of database query optimization

2022-04-23 07:42:00 【cqwoniu】

Catalog

One 、 What are the indicators to measure query overhead
Two 、 What factors lead to slow query speed
3、 ... and 、 How to optimize

One 、 What are the indicators to measure query overhead

response time
Number of scanning lines
Number of rows returned

Two 、 What factors lead to slow query speed

Search for unnecessary records .
Returns all columns when the table is associated
Always take out all columns

3、 ... and 、 How to optimize

1. Use index
The easiest and fastest way to get results is to give your conditions （ primary key , General index , Unique index, etc ）.
2、 Use joins instead of subqueries
3、 Use federated queries instead of creating temporary tables
4、 Business
5、 Using the foreign key
6、 Optimize the query method
Examples of optimizing query statements

版权声明
本文为[cqwoniu]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204230622031840.html