EXPLAIN extended SELECT me.id_domain, me.domain_name, me.registered, me.delegated, me.id_person, me.id_registrar, me.id_org, me.created, me.paid_till, me.free_date, me.real_free_date, me.owner, me.registrar, me.yandex_tic, me.google_pr, me.date_add, me.date_delete, me.first_create_date FROM ru_stat_domains me WHERE ( delegated = 'DELEGATED' ) ORDER BY owner ASC LIMIT 1177450, 50 \G;
*************************** 1. row ***************************
           id: 1
  select_type: SIMPLE
        table: me
         type: ref
possible_keys: delegated_2
          key: delegated_2
      key_len: 1
          ref: const
         rows: 1115212
        Extra: Using where; Using filesort
1 row in set, 1 warning (0.02 sec)