Vlet

*************************** 1. row ***************************
     Id: 3
   User: root
   Host: localhost:2211
     db: netflix
Command: Query
   Time: 29497
  State: Locked
   Info: ALTER TABLE `netflix`.`qualifying` ADD UNIQUE `idx_qualifying`(`cust_id`, `movie_id`)
, ENGINE = MyISAM
*************************** 2. row ***************************
     Id: 11
   User: netflix
   Host: localhost:2350
     db: netflix
Command: Query
   Time: 29826
  State: Copying to tmp table
   Info: select distinct
        qualifying.cust_id,
        customers.num_peers,
        customers.rating_cutoff
from
        qualifying
join customers on
        customers.cust_id = qualifying.cust_id
where
        customers.num_peers > 0 and
        qualifying.rating = 0
order by
        qualifying.cust_id
*************************** 3. row ***************************
     Id: 12
   User: root
   Host: localhost:2353
     db: NULL
Command: Query
   Time: 0
  State: NULL
   Info: show full processlist
*************************** 4. row ***************************
     Id: 13
   User: root
   Host: localhost:2354
     db: mysql
Command: Sleep
   Time: 3
  State:
   Info: NULL