MySQL Forums :: Partitioning :: Mysql 5.5 Partittioning row field


Advanced Search

Re: Mysql 5.5 Partittioning row field
Posted by: Jonathan Stephens ()
Date: June 25, 2015 10:16AM

The rows column in EXPLAIN output refers to the number of rows that MySQL needs to check, not the number that would be returned by the statement.

See http://dev.mysql.com/doc/refman/5.6/en/explain-output.html#explain_rows

Jon Stephens
MySQL Documentation Team @ Oracle
Stockholm, Sweden

MySQL Dev Zone
MySQL Server Documentation
Oracle

Options: ReplyQuote


Subject Views Written By Posted
Mysql 5.5 Partittioning row field 1354 Shubham Jain 06/24/2015 10:19PM
Re: Mysql 5.5 Partittioning row field 978 Jonathan Stephens 06/25/2015 10:16AM
Re: Mysql 5.5 Partittioning row field 802 Rick James 06/26/2015 12:15AM
Re: Mysql 5.5 Partittioning row field 957 Jonathan Stephens 06/26/2015 02:40AM
Re: Mysql 5.5 Partittioning row field 831 Shubham Jain 06/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.