MySQL Forums :: Performance :: seeking for better solution to change indexed column size


Advanced Search

seeking for better solution to change indexed column size
Posted by: Joy Zhao ()
Date: December 22, 2010 03:56PM

I have a big column with size of 1024. The index (at char size 1000) has been there for the column and there are more than .5 billion data in the table. Now I have to do something to improve the performance.

I evaluated that 200 is good enough. I tried to drop off the index and tried to modify the column size to 200. I am not able to get the process successfully done.

Could someone give a suggestion what else I need to try.

Thanks for any feedback.

Options: ReplyQuote


Subject Views Written By Posted
seeking for better solution to change indexed column size 1887 Joy Zhao 12/22/2010 03:56PM
Re: seeking for better solution to change indexed column size 682 Rick James 12/24/2010 10:19AM
Re: seeking for better solution to change indexed column size 559 Joy Zhao 12/24/2010 01:30PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.