Jump to content

finnMacCool

New Members
  • Posts

    1
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

finnMacCool's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. [!--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!
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.