ary 04, 2002 10:34 PM
Subject: Re: How to index Optimization on 20 million record
> Hery,
> You need to get some idea of how many records are being counted.
> What I suggest is to put a Limit on your select statement and gradually
> increase it.
>
> For example
> sel
quot;?
Brent
At 03:08 AM 2/4/2002 , you wrote:
>- Original Message -
>From: "David Phillips" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Monday, February 04, 2002 4:01 PM
>Subject: Re: How to index Optimization on 20 million record
&g
Hery Yulianto a écrit :
>
> - Original Message -
> From: "David Phillips" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, February 04, 2002 4:01 PM
> Subject: Re: How to index Optimization on 20 million record
>
> > &
- Original Message -
From: "David Phillips" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 04, 2002 4:01 PM
Subject: Re: How to index Optimization on 20 million record
> > PRIMARY KEY (`FIELD_1`),
> > KEY `FIELD_1` (`FIELD_1`
> PRIMARY KEY (`FIELD_1`),
> KEY `FIELD_1` (`FIELD_1`),
You don't need a second key on the column, as it is a duplicate of the
primary key.
> but, i do query sintax, just simple select count(*) from TABLE_1
where
> FIELD_1 = "XXX_CC";
> But i got the result very long timemore 10 mi
Hi Brothers and Sisters,
I need to know how to optimazion index in MySQL, i was read on the manual,
but i did not found solution.
My case, i have a 20 million record on the one table, yhe table name TABLE_1
i have a field on TABLE_! as indexed and primary key named FIELD_1
(varchar(64) not null
