search for: index_tokens_on_fnv_and_user_id

Displaying 1 result from an estimated 1 matches for "index_tokens_on_fnv_and_user_id".

2010 Jul 20
4
MySQL index question
I am trying to speed up some DB operations and perhaps have gone overboard with indexes. Does MySQL usually use only one index per query and simply match keys on the results of the indexed first part? For example: DELETE FROM tokens WHERE 6813946236211560448 <= fnv AND fnv < 6818449835838930944 AND updated_at<''2010-06-20 14:08:55'' AND occurrences=0; If I understand