[rt-users] Re: Slow Queries

[Jon Daley]

 	It is impossible to add an index without hurting the insert 
queries; the question if it hurts it significantly enough for you to 
notice.  I would just try creating one and see what happens, you can 
always delete it later if it makes the inserts/updates too slow.

On Sun, 22 Oct 2006, Asif Iqbal wrote:
> 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:
>> 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
>> SELECT * FROM Transactions where Transactions.type = 'create';
>> 
>> 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?