Mysql 5.5 Partittioning row field
I have created a partition on my table based on a column value. I am using mysql 5.5
ALTER TABLE tab partition by list(ARCHIVE) (partition p0 values in (0), partition p1 values in (1));
Now when I am running following commands:-
1. select count(*) from tab where archive=0;
In this, no of rows is coming as 198182
2. explain partitions select count(*) from tab where archive=0;
In output of this command, in row field I am getting 195934
Can someone explain why there is a difference between 2 results? Is rows field in explain partitions mean something else?
Please explain.
Subject
Views
Written By
Posted
Mysql 5.5 Partittioning row field
2441
June 24, 2015 10:19PM
1672
June 25, 2015 10:16AM
1472
June 26, 2015 12:15AM
1665
June 26, 2015 02:40AM
1410
June 26, 2015 07:02AM
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.