yes. ----- Original Message ----- From: "Martijn Tonies" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <mysql@lists.mysql.com> Sent: Thursday, April 12, 2007 1:43 AM Subject: Re: when rebuilding keys?
> > > >> before load data. > > You want to rebuild the indices after loading data, > correct? > > Martijn Tonies > Database Workbench - development tool for MySQL, and more! > Upscene Productions > http://www.upscene.com > My thoughts: > http://blog.upscene.com/martijn/ > Database development questions? Check the forum! > http://www.databasedevelopmentforum.com > > > >> >> My table is myisam. >> >> >> >> I disable key using "alter table ... disable keys" before load data in > the >> > table. >> >> >> >> The manual tell me MySQL to stop updating non-unique indexes for a > MyISAM >> > table. >> >> >> >> When mysql server updating non-unique index after loading data? >> > >> > When you run ALTER TABLE ... ENABLE KEYS > >
