Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> explain SELECT members.twitter_id FROM `members` INNER JOIN `twitter_identities` ON twitter_identities.persona_id = members.persona_id WHERE (user_id = 266 AND (member_state > 1 OR high_value_type > 0) AND twitter_identities.updated_at < '2013-01-01 09:12:55') LIMIT 100\G;
- *************************** 1. row ***************************
- id: 1
- select_type: SIMPLE
- table: members
- type: ref
- possible_keys: user_id,starred_index,hidden_index,members_state_index,high_value_members_index,twitter_id_index,persona_id_index
- key: user_id
- key_len: 4
- ref: const
- rows: 1
- Extra: Using where
- *************************** 2. row ***************************
- id: 1
- select_type: SIMPLE
- table: twitter_identities
- type: ref
- possible_keys: updated_at_index,index_twitter_identities_on_persona_id
- key: index_twitter_identities_on_persona_id
- key_len: 5
- ref: communit_pablo.members.persona_id
- rows: 1
- Extra: Using where
- 2 rows in set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement