count(1)和count(*)取舍 之前也不知道在哪看到的或聽說的,count(1) 比count(*) 效率高,這是錯誤的認(rèn)知,官網(wǎng)上有這么一句話,InnoDB handles SELECT COUNT( *) and SELECT COUNT(1) operations in the same way. There is no performance difference. 翻譯過來就是,InnoDB以同樣的方式處理SELECT COUNT( *)和...
www.dbjr.com.cn/article/2394...htm 2025-5-25