Bonjour,
Mysql-3.23.37 with latest patch (patch of the patch from Heikki :)
) under Solaris 2.8 (SPARC 64bit).
I have a table :
CREATE TABLE mybuffer (
id int(10) unsigned NOT NULL auto_increment,
bourse char(3) NOT NULL default '',
service varchar(10) NOT NULL default '',
date
Alex,
can you print the EXPLAIN SELECT ... for the count(*) and the other query?
Regards,
Heikki
At 12:03 PM 5/9/01 +0200, you wrote:
Bonjour,
Mysql-3.23.37 with latest patch (patch of the patch from Heikki :)
) under Solaris 2.8 (SPARC 64bit).
I have a table :
CREATE TABLE
Heikki,
HT can you print the EXPLAIN SELECT ... for the count(*) and the other query?
mysql explain select count(*) from mybuffer where bourse='NAS';
+--+--+---+---+-+---+--+-+
| table| type | possible_keys | key