SQL data query optimization, how to handle

SQL data Query optimization
Select A.id,rkno,a.packageno as Packageno,cust_no,lotno,count (*) as Count from ' Rk_record ' as a right join ' sys_barcode_1d _y ' as B on a.packageno = B.packageno where rkno = ' 201401030031 ' GROUP by Packageno,lotno ORDER by Packageno,lotno ASC

The Rkno,packageno index is included.

Currently the query needs more than 4,000 MS, is there any way to optimize the SQL statement?

share to: more

------Solution--------------------
b Table no index is used

Try to A.packageno = B.packageno
Writing B.packageno = A.packageno
------Solution--------------------
The B table field is not used in the index to see if the association fields of B are new indexes.

