Re: mysql 5.5 to mysql 5.7

[mark cabantog]

----- 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