MySQL Forums
Forum List  »  Memory Storage Engine

Index with same columns as table
Posted by: Holger Haag
Date: September 07, 2008 02:01PM

Hello,

I've got a table with an index that contains all columns of this table. The table is always accessed via the index. So the same data is basically stored twice - in the index and in the actual table.

This was never a big issue when InnoDB/MyIsam was used since disk space is cheap. But with the memory engine, this becomes an issue (the table is about 2.5 GB).

Is there an option to sort the table automatically so that the index is not necessary?

Thanks
Holger

Options: ReplyQuote


Subject
Views
Written By
Posted
Index with same columns as table
6865
September 07, 2008 02:01PM


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.