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 functioning
I tried using 'USE INDEX
.
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 functioning
I tried using 'USE INDEX' and 'BETWEEN' but it didn't change anything.
EXPLAIN
]
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 waste of time, but you
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',
, 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 that were created
-
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 optimizer is informing you that `it` believes a table scan is more
efficient than using
?
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: RE: Index not functioning
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.
EXPLAIN SELECT counter, UNIX_TIMESTAMP(dtime) FROM
ifInOctets_137
USE INDEX