[rt-users] Slow Queries

[Asif Iqbal]

Hi

I am noticing from my slow log file (5 secs) that the following query
on mysql 4.0.24 is taking a 11 secs

# Query_time: 11  Lock_time: 0  Rows_sent: 299925  Rows_examined: 983836
use rt3;
SELECT * FROM Transactions where Transactions.type = 'create';

Now looking at the explain I see

mysql> explain SELECT * FROM Transactions where Transactions.type = 'create';
+--------------+------+---------------+------+---------+------+--------+-------------+
| table        | type | possible_keys | key  | key_len | ref  | rows
| Extra       |
+--------------+------+---------------+------+---------+------+--------+-------------+
| Transactions | ALL  | NULL          | NULL |    NULL | NULL | 984572
| Using where |
+--------------+------+---------------+------+---------+------+--------+-------------+

It has to go thru about 1 million rows and not using any index.

Is there any index, that I can create, to improve this w/o hurting any
other query?

-- 
Asif Iqbal
PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu