mysql> explain select downloadco0_.id as id1_9_, downloadco0_.attempts as attempts2_9_, downloadco0_.dateCreated as dateCrea3_9_, downloadco0_.dateModified as dateModi4_9_, downloadco0_.downloadCompleted as download5_9_, downloadco0_.downloadStarted as download6_9_, downloadco0_.executionId as executio7_9_, downloadco0_.fileId as fileId8_9_, downloadco0_.fileSize as fileSize9_9_, downloadco0_.fulfillerId as fulfill10_9_, downloadco0_.platform as platfor11_9_ from DownloadConfirmation downloadco0_ where downloadco0_.platform='EU' and downloadco0_.fulfillerId='12' and downloadco0_.executionId='103906' and (downloadco0_.downloadCompleted is not null) order by downloadco0_.downloadCompleted asc limit 10\G
*************************** 1. row ***************************
id: 1
select_type: SIMPLE
table: downloadco0_
type: ref
possible_keys: platformFulfillerIdExecutionId,downloadCompleted
key: platformFulfillerIdExecutionId
key_len: 824
ref: const,const,const
rows: 977
Extra: Using index condition; Using where; Using filesort
1 row in set (0.00 sec)
Even with bigger limit numbers it performs well:
mysql> explain select downloadco0_.id as id1_9_, downloadco0_ .attempts as attempts2_9_, downloadco0_ .dateCreated as dateCrea3_9_, downloadco0_ .dateModified as dateModi4_9_, downloadco0_ .downloadComple ted as download5_9_, downloadco0_ .downloadStarte d as download6_9_, downloadco0_ .executionId as executio7_9_, downloadco0_.fileId as fileId8_9_, downloadco0_ .fileSize as fileSize9_9_, downloadco0_ .fulfillerId as fulfill10_9_, downloadco0_ .platform as platfor11_9_ from DownloadConfirm ation downloadco0_ where downloadco0_ .platform= 'EU' and downloadco0_ .fulfillerId= '12' and downloadco0_ .executionId= '103906' and (downloadco0_ .downloadComple ted is not null) order by downloadco0_ .downloadComple ted asc limit 10\G ******* ******* ****** 1. row ******* ******* ******* ****** erIdExecutionId ,downloadComple ted erIdExecutionId
*******
id: 1
select_type: SIMPLE
table: downloadco0_
type: ref
possible_keys: platformFulfill
key: platformFulfill
key_len: 824
ref: const,const,const
rows: 977
Extra: Using index condition; Using where; Using filesort
1 row in set (0.00 sec)