search

niftyisucon / isucon13

0 stars 0 forks source link

livestream_tagsにインデックス追加 #5

Closed Penpen7 closed 10 months ago

Penpen7 commented 10 months ago 
mysql> EXPLAIN SELECT * FROM livestream_tags WHERE livestream_id = 7523\G
*************************** 1. row ***************************
           id: 1
  select_type: SIMPLE
        table: livestream_tags
   partitions: NULL
         type: ALL
possible_keys: NULL
          key: NULL
      key_len: NULL
          ref: NULL
         rows: 11484
     filtered: 10.00
        Extra: Using where
1 row in set, 1 warning (0.00 sec)