Hello.
Here is the answer from Ingo:
"It is even worse. The old index stays in place, but will never be used
again. ENABLE INDEX creates a new index from scratch. See Bug#4692 -
DISABLE/ENABLE KEYS waste a space."
roi h <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Another question, to
Hi,
Another question, to help me better understand MySQL indexing:
In MyISAM, does DISABLE INDEX followed by insertions and then
ENABLE INDEX freeze the original index and batch-updates it, or does
it drop it completely and recreate it from scratch?
--thanks, Roi
--
MySQL General Mailing List