Hi,
I'm new to the list and I am just wondering..
Why don't you guys use a fixed font when pasting mysql queries..
Wouldn't it better to see something like this 'Monaco font on Mac OS X':
mysql> explain select sum(size) from message where uid='2945';
+---------+------+---------------+------+---------+-------+------
+-------------+
| table | type | possible_keys | key | key_len | ref | rows |
Extra |
+---------+------+---------------+------+---------+-------+------
+-------------+
| message | ref | uid | uid | 4 | const | 2491 |
Using where |
+---------+------+---------------+------+---------+-------+------
+-------------+
Than this ?
mysql> explain select sum(size) from message where uid='2945';
+---------+------+---------------+------+---------+-------+------
+-------------+
| table | type | possible_keys | key | key_len | ref | rows |
Extra |
+---------+------+---------------+------+---------+-------+------
+-------------+
| message | ref | uid | uid | 4 | const | 2491 |
Using where |
+---------+------+---------------+------+---------+-------+------
+-------------+
Just a thought.
Jerry
- How to speed up query? Ganbold
- Re: How to speed up query? Kelley Lingerfelt
- Re: How to speed up query? Egor Egorov
- Re: How to speed up query? Ganbold
- Re: Fixed Font Jerry Rocteur
- Re: Fixed Font jabbott
- Re: Fixed Font Jerry Rocteur
- Re: Fixed Font gerald_clark
- Re: Fixed Font Gabriel Ricard
- Re: Fixed Font Yves Goergen
- Re: How to speed up query? Matt W