14 pointsby socrateesover 16 years ago

3 comments

jrockwayover 16 years ago

SQL is Not C <example code>I would be very surprised if the optimizer did not treat his two example queries the same.

评论 #365232 未加载

bradgesslerover 16 years ago

COUNT() incurs no additional cost for a well-structured query"Well structured" query meaning there is no WHERE clause...

trueboskoover 16 years ago

Nothing like trying to read an article on mySQL optimization and I get "Error establishing database connection" .. :(

评论 #365448 未加载

10 tips for optimizing mySql queries