From: Hank
Date: November 24 2012 9:02pm
Subject: Covering Index without the data file (myisam)
List-Archive: http://lists.mysql.com/mysql/228720
Message-Id: <CAPs4VG=F7XeaqetFqf2pj=SHperNDTHA1CVjOWzvGxv=iXoSfA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1

Hello everyone,

 I know this is a longshot, but is there any way to eliminate the MYD
file for a table that has a full covering index? The index is larger
than the datafile, since it contains all the records in the datafile,
plus a second reverse index.  It seems redundant to have to also store
a MYD file.

Thanks,

-Hank