Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Comparison between count (1) and count (*) in mysql

2025-01-19 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Count details:

Count (*) will return the total number of all existing rows in the table, including those with a value of null, while count (column name) will return the total number of all rows in the table except null (columns with default values will also be counted).

Distinct column name, the result will be the result after removing the value of null and duplicate data

Sql tuning is mainly about reducing the number of consistent gets and physical reads.

Count (1) compares with count (*):

If your datasheet does not have a primary key, then count (1) is faster than count (*)

If there is a primary key, the condition of the primary key (joint primary key) as count is also faster than that of count (*).

If your table has only one field, then count (*) is the fastest.

Count (*) count (1) compare the two. The main thing is to count (1) the corresponding data field.

If count (1) is a clustered index, id, that must be count (1) fast. But the difference is very small.

Because of count (*), which field is automatically optimized for assignment. So there is no need to go to count (?), use count (*), sql will help you complete the optimization

Sum up three experiences

1. SELECT COUNT (*) FROM tablename is the best choice in any case.

two。 Minimize queries such as SELECT COUNT (*) FROM tablename WHERE COL = 'value'

3. Put an end to SELECT COUNT (COL) FROM tablename.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report