MySQL Forums
Forum List  »  Custom Storage Engines

Optimising select count(*)
Posted by: Mikhail Galanin
Date: March 23, 2017 02:08AM

Hi here,

When a user tries to get count of rows in the table, mysql performs FULLSCAN by calling rnd_*() functions.

I'm sure there must be a way to say optimiser that I can extract this information from index. Could you please advise me how I can work it out?

Options: ReplyQuote

Written By
Optimising select count(*)
March 23, 2017 02:08AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.