[A better way to write this SQL select query]

[!--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!