Comment 12 for bug 1362212

Steffen Boehme (boemm) wrote :

mysql> explain select count(downloadco0_.id) as col_0_0_ from DownloadConfirmation downloadco0_ where downloadco0_.platform='EU' and downloadco0_.fulfillerId='5' and (downloadco0_.downloadCompleted is null)\G
*************************** 1. row ***************************
           id: 1
  select_type: SIMPLE
        table: downloadco0_
         type: ref
possible_keys: platformFulfillerIdExecutionId,downloadCompleted
          key: downloadCompleted
      key_len: 779
          ref: const,const,const
         rows: 8
        Extra: Using where; Using index
1 row in set (0.00 sec)