Well, you have just invented what is known as index organized tables. The MyISAM engine
does not implement those.
If it did, it would have to deal with quite a few circumstances unique to IOTs. One
such circumstance is degradation
of efficiency with the increase of record length, another is bloating the size of
secondary indexes, and there is quite a few more...
In short, the alternative to keeping the MYD file would be much worse :-)
On 24.11.2012, at 13:02, Hank wrote:
> 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.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql