ALTER TABLE `mlf2_userdata` ADD INDEX(`user_type`);
ALTER TABLE `mlf2_userdata` ADD INDEX(`user_name`);

Should I test this? If so, how? Which operations on the forum, like viewing a thread or going to the main page, would use these indexes?

/ Daniel