----- Original Message -----
From: "Martijn Tonies" <m.tonies@stripped>
To: <wangxu@stripped>; <email@example.com>
Sent: Thursday, April 12, 2007 3:17 PM
Subject: Re: when rebuilding keys?
>> >> before load data.
>> > You want to rebuild the indices after loading data,
>> > correct?
> Then what exactly is the question?
> Please write your answer BELOW, not above.
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
> MS SQL Server
> Upscene Productions
> My thoughts:
> Database development questions? Check the forum!
sorry ,my english is poor.
There is a observable event.
My table's engine is myisam.
Rows above 1000000 in my table.
I did "alter table ......disable keys" before loading data.
I did "alter table ......enable keys" after loading data.
The operation of enable keys is so fast!
I am not sure than if the keys have been rebuild.I think the course of rebuilding should need very long time.