PROTECTED]
Sent: Monday, March 29, 2004 12:24 PM
To: Jack Coxen
Cc: '[EMAIL PROTECTED]'; MySQL List (E-mail)
Subject: RE: Index not functioning - update
just out of curiousity,
have you tried the 4.1.1 version?
there may (or may not) be something from 4.1.0 to 4.1.1
could be a total wa
x27;ll do that if I
> have to but I'd prefer to fix the existing setup of a single index on dtime.
>
> Jack
>
> -Original Message-
> From: Jack Coxen [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 24, 2004 1:51 PM
> To: '[EMAIL PROTECTED]'; MySQ
7;ll do that if I
have to but I'd prefer to fix the existing setup of a single index on dtime.
Jack
-Original Message-
From: Jack Coxen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 24, 2004 1:51 PM
To: '[EMAIL PROTECTED]'; MySQL List (E-mail)
Subject: RE: Index not fun
; From: Jack Coxen [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 24, 2004 11:51 AM
> To: '[EMAIL PROTECTED]'; MySQL List (E-mail)
> Subject: RE: Index not functioning
>
>
> I tried using 'USE INDEX' and 'BETWEEN' but it didn't change anything.
sec)
Is my syntax wrong?
The resultset size should be around 8640 rows - 5 minute interval data for
30 days - 12 X 24 X 30 = 8640
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 24, 2004 1:22 PM
To: Jack Coxen; MySQL List (E-mail)
Subject:
gt; Jack
>
> -Original Message-
> From: Victor Pendleton [ mailto:[EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]> ]
> Sent: Wednesday, March 24, 2004 12:24 PM
> To: Jack Coxen; MySQL List (E-mail)
> Subject: Re: Index not functioning
>
>
> The optimiz
, 2004 12:24 PM
To: Jack Coxen; MySQL List (E-mail)
Subject: Re: Index not functioning
The optimizer is informing you that `it` believes a table scan is more
efficient than using an index due to the resultset size.
On Wed,
24 Mar 2004, Jack Coxen wrote: >
> I have a series of tables tha
The optimizer is informing you that `it` believes a table scan is more
efficient than using an index due to the resultset size.
On Wed,
24 Mar 2004, Jack Coxen wrote: >
> I have a series of tables that were created by:
>
> CREATE TABLE ifInOctets (
> id int(11) NOT NULL default '0