[rt-users] Re: Slow Queries

[Asif Iqbal]

Resending my question in case anyone missed to catch it the first time around.

On 10/9/06, Asif Iqbal <vadud3 at gmail.com> wrote:
> 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
>


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