From: Reindl Harald
Date: November 24 2012 9:15pm
Subject: Re: Covering Index without the data file (myisam)
List-Archive: http://lists.mysql.com/mysql/228721
Message-Id: <50B13901.9020103@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig62BD84982E40272BC0010240"

--------------enig62BD84982E40272BC0010240
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable



Am 24.11.2012 22:02, schrieb Hank:
> Hello everyone,
>=20
>  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

simple answer: NO


--------------enig62BD84982E40272BC0010240
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
Comment: Using GnuPG with undefined - http://www.enigmail.net/

iEYEARECAAYFAlCxOQEACgkQhmBjz394AnlQZACfc+RLKqcEfFIQXr4Hw5+cL4Iq
7Q0AnjIhm2/2XswNIQ3G+vgy5OZSKD5/
=JYU5
-----END PGP SIGNATURE-----

--------------enig62BD84982E40272BC0010240--