Re: Indexing implementation

2005-06-09 Thread Gleb Paharenko
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

Indexing implementation

2005-06-08 Thread roi h
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