> >> >> 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.
>
> sorry ,my english is poor.
>
> There is a observable event.
> My table's engine is myi
From: wangxu Sent: Thu 12/04/2007 08:38
> - Original Message -
> From: "Martijn Tonies" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Thursday, April 12, 2007 3:17 PM
> Subject: Re: when rebuilding keys?
&
- Original Message -
From: "Martijn Tonies" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, April 12, 2007 3:17 PM
Subject: Re: when rebuilding keys?
>
>
>> yes.
>
>> >> before load data.
>&
> yes.
> >> 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
Upscen
yes.
- Original Message -
From: "Martijn Tonies" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>;
Sent: Thursday, April 12, 2007 1:43 AM
Subject: Re: when rebuilding keys?
>
>
>
>> before load data.
>
> You want to rebuild the indices after l
> 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!
h
before load data.
- Original Message -
From: "Martijn Tonies" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>;
Sent: Wednesday, April 11, 2007 7:45 PM
Subject: Re: when rebuilding keys?
>
>
>
>> My table is myisam.
>>
>> I disable key
> 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 ... ENABL