Comment 13 for bug 1362212

Steffen Boehme (boemm) wrote :

mysql> explain select 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 1\G
*************************** 1. row ***************************
           id: 1
  select_type: SIMPLE
        table: downloadco0_
         type: range
possible_keys: platformFulfillerIdExecutionId,downloadCompleted
          key: downloadCompleted
      key_len: 6
          ref: NULL
         rows: 403364
        Extra: Using where
1 row in set (0.00 sec)