[!--quoteo(post=343546:date=Feb 7 2006, 03:55 PM:name=wickning1)--][div class=\'quotetop\']QUOTE(wickning1 @ Feb 7 2006, 03:55 PM) [snapback]343546[/snapback][/div][div class=\'quotemain\'][!--quotec--] Go to the structure page for the table in question. Below the column listing there is a listing of all the indexes. Type 10 for "Create an index on __ columns". Click "Go" Select all 10 columns from the dropdown, in the order you will query them (year, size, etc...) Click "Save" Wait for the index to be created (could be a while if the table has a lot of rows). Now you can use that same index list to delete all the individual fulltext indexes. They are wasting space and speed. [/quote] thanks wikning1, saved me much head banging of the brick wall variety! I owe you 1!