Re: CREATE INDEX is sooo slow! any ideas?

[Michael T. Babcock]

> At 06:27 PM 2/16/2003 -0500, Peter Grigor wrote:
>
>> Well, MySql stores all its index information in one index file, so 
>> when you
>> add another index it has to rebuild the WHOLE file. :)
>

Anyone on the MySQL team feel like explaining that design decision, 
besides historical reasons?  I doubt its any more efficient except in 
file descriptor usage (although I've expressed the same doubts about 
InnoDB's avoidance of the filesystem too).

SQL and all that ...

-- 
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock