TechnocratTechnocrat’s Random Thoughts

So I have tested all my first set of indexes and after realizing that going overboard was a bad idea.  But I have some more that have really helped.  This will probably be my last set of them.

ALTER TABLE `nuke_stories_cat` ADD INDEX ( `title` );
ALTER TABLE `nuke_donators` ADD INDEX ( `dondate` );
ALTER TABLE `nuke_downloads_downloads` ADD INDEX ( `hits` );
ALTER TABLE `nuke_downloads_downloads` ADD INDEX ( `active` );
ALTER TABLE `nuke_evo_userinfo` ADD INDEX ( `active` );
ALTER TABLE `nuke_modules` ADD INDEX `active_inmenu_catid` ( `active` , `inmenu` , `cat_id` );
ALTER TABLE `nuke_modules_cat` ADD INDEX ( `pos` );
ALTER TABLE `nuke_modules` ADD INDEX ( `inmenu` );
ALTER TABLE `nuke_users` ADD INDEX ( `user_level` );