Re: mysql 5.5 to mysql 5.7
----- mysql 5.5 ----
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY acct_invoice ALL inv_no 4712
1 PRIMARY acct_invoice_det ref inv_no inv_no 5 mysql5_847086_ais2011.acct_invoice.inv_no 2 Using where
3 DEPENDENT SUBQUERY rv ref inv_no inv_no 5 mysql5_847086_ais2011.acct_invoice_det.inv_no 1 Using where
2 DEPENDENT SUBQUERY rv ref inv_no inv_no 5 mysql5_847086_ais2011.acct_invoice_det.inv_no 1 Using where
------ mysql 5.7 -----
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 PRIMARY acct_invoice ALL inv_no 4719 100 Using where
1 PRIMARY acct_invoice_det ref inv_no inv_no 5 mysql5_847086_ais2011.acct_invoice.inv_no 4 100
3 DEPENDENT SUBQUERY rv ref inv_no inv_no 5 mysql5_847086_ais2011.acct_invoice_det.inv_no 1 100
2 DEPENDENT SUBQUERY rv ref inv_no inv_no 5 mysql5_847086_ais2011.acct_invoice_det.inv_no 1 100
Subject
Written By
Posted
Re: mysql 5.5 to mysql 5.7
May 08, 2017 02:06AM
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.