3:48 PM
To: mysql@lists.mysql.com
Subject: Re: query tuning
Rick,
Thanks! Here is the create table info. Sorry for the size, but you can skip
down from all the fields to see the indexes.
CREATE TABLE `exams` (
`zAddDate` date DEFAULT NULL,
`zModDate` date DEFAULT NULL,
`IdPatient
of key_buffer_size? It should generally be 20% of _available_
RAM (for MyISAM usage).
-Original Message-
From: James W. McNeely [mailto:jmcne...@nwrads.com]
Sent: Wednesday, November 14, 2012 3:48 PM
To: mysql@lists.mysql.com
Subject: Re: query tuning
Rick,
Thanks! Here is the create table info. Sorry
I have a query I'm having trouble with. If do this query which is DATE plus
ProcModecode, it is very fast:
SELECT e.zzk FROM exams e
-- JOIN Appt_ a ON e.IdAppt = a.IdAppt
-- JOIN Affil_ af ON a.IdAffil_primary = af.IdAffil
WHERE e.dateexam = '2012-09-01' AND e.dateexam = '2012-09-30'
AND
[mailto:jmcne...@nwrads.com]
Sent: Wednesday, November 14, 2012 2:34 PM
To: mysql@lists.mysql.com
Subject: query tuning
I have a query I'm having trouble with. If do this query which is DATE plus
ProcModecode, it is very fast:
SELECT e.zzk FROM exams e
-- JOIN Appt_ a ON e.IdAppt = a.IdAppt
) -- in that order
(I can't predict which index it would use.)
Are IdAppt the same datatype and collation in each table?
-Original Message-
From: James W. McNeely [mailto:jmcne...@nwrads.com]
Sent: Wednesday, November 14, 2012 2:34 PM
To: mysql@lists.mysql.com
Subject: query tuning
I have
Message-
From: James W. McNeely [mailto:jmcne...@nwrads.com]
Sent: Wednesday, November 14, 2012 3:48 PM
To: mysql@lists.mysql.com
Subject: Re: query tuning
Rick,
Thanks! Here is the create table info. Sorry for the size, but you can skip
down from all the fields to see the indexes
Hi All,
I am using mysql 5.0.41, on debian, with 8 CPU, 8 GB RAM.
I am having the below query with explain plan
select * from (select * from (select truncate0.34*LOG(10,((NO_BIDS +
1)/(TOTAL_QTY
+ 1 + (0.24*LOG(10,100*( (SOLD_QTY + 1) / (TOTAL_QTY + 1 + 0.14*(1
/ LOG(10, 10 +