Hi
I have index on field "dstn"
But query
select sum(usd) from fin_journal where dstn like 'O%' AND
date>='2001-06-01 00:00:00' AND date<'2001-07-01 00:00:00' AND descr IN
('abonplata POP3', 'registration POP3') group by dstn,dsuba,ident ;
don't use in.
In manual I found than indexes are using in LIKE
How can I see that index is used?
explain select sum(usd) from fin_journal where dstn like 'O%' AND
date>='2001-06-01 00:00:00' AND date<'2001-07-01 00:00:00' AND descr IN
('abonplata POP3', 'registration POP3') group by dstn,dsuba,ident ;
+-------------+------+---------------+------+---------+------+-------+-----------------------------+
| table | type | possible_keys | key | key_len | ref | rows |
Extra |
+-------------+------+---------------+------+---------+------+-------+-----------------------------+
| fin_journal | ALL | dstn | NULL | NULL | NULL | 39797 |
where used; Using temporary |
+-------------+------+---------------+------+---------+------+-------+-----------------------------+
If I see possible_keys->dstn, is this indes in use?
mysql>
show index from fin_journal;
+-------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name |
Collation | Cardinality | Sub_part | Packed | Comment |
+-------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+---------+
| fin_journal | 1 | KEY1 | 1 | d | A
| NULL | NULL | NULL | |
| fin_journal | 1 | KEY1 | 2 | dstn | A
| NULL | NULL | NULL | |
| fin_journal | 1 | KEY2 | 1 | d | A
| NULL | NULL | NULL | |
| fin_journal | 1 | KEY2 | 2 | dsuba | A
| NULL | NULL | NULL | |
| fin_journal | 1 | KEY3 | 1 | c | A
| NULL | NULL | NULL | |
| fin_journal | 1 | KEY3 | 2 | cstn | A
| NULL | NULL | NULL | |
| fin_journal | 1 | KEY4 | 1 | c | A
| NULL | NULL | NULL | |
| fin_journal | 1 | KEY4 | 2 | csuba | A
| NULL | NULL | NULL | |
| fin_journal | 1 | k_sesid | 1 | sesid | A
NULL | NULL | NULL | |
| fin_journal | 1 | dsuba | 1 | dsuba | A
| NULL | NULL | NULL | |
| fin_journal | 1 | ident | 1 | ident | A
| NULL | NULL | NULL | |
| fin_journal | 1 | csuba | 1 | csuba | A
| NULL | NULL | NULL | |
| fin_journal | 1 | dstn | 1 | dstn | A
| NULL | NULL | NULL | |
+-------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+---------+
_______________________________________
Andrey Kotrekhov [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
