Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
Description
Hello Team,
I would like to know if there are any faster alternatives or optimizations available to retrieve the exact row count in InnoDB engines without resorting to estimated counts.
While I understand that certain techniques (like using SHOW TABLE STATUS or INFORMATION_SCHEMA) can be used for estimates, I specifically need the exact row count. Is there any way to retrieve the exact row count faster instead of count()?
Attachments
Issue Links
- duplicates
-
MDEV-18188 Maintain persistent COUNT(*) in InnoDB
-
- Stalled
-