before load data. ----- Original Message ----- From: "Martijn Tonies" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <mysql@lists.mysql.com> Sent: Wednesday, April 11, 2007 7:45 PM Subject: Re: when rebuilding keys?
> > > >> 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 > > 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 > >