Thank you Dan,
I will try that.
Mikhail Berman
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 03, 2006 5:29 PM
To: Mikhail Berman
Cc: Chris White; mysql@lists.mysql.com
Subject: Re: Q2. Is there anything could be done to speed up this query
In the
On Wednesday 03 May 2006 12:16 pm, Mikhail Berman wrote:
I have a table:
CREATE TABLE `TICKER_HISTORY_PRICE_DATA_STAGING_NO_KEYS` (
`price_data_ticker` char(8) NOT NULL default '',
`price_data_date` date NOT NULL default '-00-00',
`price_data_open` float default NULL,
Thank you, Chris
But the table is indexed on the field you are referring to and the other
one the query, which is evident from this:
KEY `prdadadx` (`price_data_date`),
KEY `prdatidx` (`price_data_ticker`)
And this:
ll TICKER_HISTORY_PRICE_DATA_STAGING_NO_KEYS.*
-rw-rw 1 mysql
In the last episode (May 03), Mikhail Berman said:
Thank you, Chris
But the table is indexed on the field you are referring to and the other
one the query, which is evident from this:
KEY `prdadadx` (`price_data_date`),
KEY `prdatidx` (`price_data_ticker`)
These are two separate