MySQL Forums
Forum List  »  Performance

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
2760
December 22, 2010 03:56PM


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.