MySQL Forums
Forum List  »  MyISAM

Table doubled in size due to index, way to remove this duplicate data?
Posted by: Josh Irish
Date: August 26, 2010 05:24AM

Hi All,

Got a table that is just an index and a telephone number, needs to be queried for a number constantly so put an index on the number field, this makes the table 5GB up from 2.6GB though.

Is there anyway to just have the table save the number fields in order like it does the index, so that I can search it quickly without doubling the size?

Thanks!

Options: ReplyQuote


Subject
Views
Written By
Posted
Table doubled in size due to index, way to remove this duplicate data?
3352
August 26, 2010 05:24AM


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.