MySQL Forums
Forum List  »  MyISAM

Re: Table doubled in size due to index, way to remove this duplicate data?
Posted by: Aftab Khan
Date: September 07, 2010 02:21AM

Yes you can have table sorted in a specifc order, Note that the table does not remain in this order after inserts and deletes. This option is useful primarily when you know that you are mostly to query the rows in a certain order most of the time. By using this option after major changes to the table, you might be able to get higher performance. In some cases, it might make sorting easier for MySQL if the table is in order by the column that you want to order it by later.

In your case I suspect you are using innodb, so sorting the table in a specific order *does not make* sense that contain a user-defined clustered index (PRIMARY KEY or NOT NULL UNIQUE index). InnoDB always orders table rows according to such an index if one is present

FYI: you can use ALTER TABLE to sort the rows in a specific order, that is, ALTER TABLE tablename ORDER BY columnname ASC;

I'll like to see the info that Rick has requested?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Table doubled in size due to index, way to remove this duplicate data?
1818
September 07, 2010 02:21AM


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.