show index from gwarp;
mysql>
+-------+------------+------------+--------------+-------------+-----------+
-------------+----------+--------+---------+
-> | Table | Non_unique | Key_name | Seq_in_index | Column_name |
Collation | Cardinality | Sub_part | Packed | Comment |
->
+-------+------------+------------+--------------+-------------+-----------+
-------------+----------+--------+---------+
-> | gwarp | 1 | ipindex | 1 | ip | A
| 165538 | NULL | NULL | |
-> | gwarp | 1 | macindex | 1 | mac | A
| 167902 | NULL | NULL | |
-> | gwarp | 1 | esnindex | 1 | esn | A
| 165538 | NULL | NULL | |
-> | gwarp | 1 | esnindex | 2 | timerecord | A
| 11753202 | NULL | NULL | |
-> | gwarp | 1 | sitename | 1 | sitename | A
| 238 | NULL | NULL | |
-> | gwarp | 1 | timerecord | 1 | timerecord | A
| 132 | NULL | NULL | |
->
+-------+------------+------------+--------------+-------------+-----------+
-------------+----------+--------+---------+
then
i use explain to analyze
mysql> explain select * from gwarp where timerecord = '02052810000' ;
+-------+------+---------------+------+---------+------+----------+---------
---+
| table | type | possible_keys | key | key_len | ref | rows | Extra
|
+-------+------+---------------+------+---------+------+----------+---------
---+
| gwarp | ALL | timerecord | NULL | NULL | NULL | 11753202 | where
used |
+-------+------+---------------+------+---------+------+----------+---------
---+
1 row in set (0.00 sec)
Pls help timercord index is not hit !! why ? how to amend ?
---------------------------------------------------------------------
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
