|
Тема |
Re: USE/FORCE INDEX [re: Bълk] |
|
Автор |
mr.vain (пътник 57) |
|
Публикувано | 03.08.07 11:49 |
|
|
mysql> show index from v8_main;
+---------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+---------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| v8_main | 0 | PRIMARY | 1 | id | A | 1675502 | NULL | NULL | | BTREE | |
| v8_main | 1 | empID_IDX | 1 | empID | A | 341 | NULL | NULL | YES | BTREE | |
| v8_main | 1 | msisdn_IDX | 1 | msisdn | A | 837751 | NULL | NULL | YES | BTREE | |
| v8_main | 1 | themeID_IDX | 1 | themeID | A | 167550 | NULL | NULL | YES | BTREE | |
| v8_main | 1 | themeID_IDX | 2 | handlingID | A | 167550 | NULL | NULL | YES | BTREE | |
| v8_main | 1 | monthStat_IDX | 1 | ph1008 | A | 13 | NULL | NULL | YES | BTREE | |
| v8_main | 1 | monthStat_IDX | 2 | handlingID | A | 121 | NULL | NULL | YES | BTREE | |
+---------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
7 rows in set
mysql> show index from v8_themes
;
+-----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+-----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| v8_themes | 0 | PRIMARY | 1 | themeID | A | 232 | NULL | NULL | | BTREE | |
+-----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
1 row in set
mysql> show index from v8_handling_types
;
+-------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+-------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| v8_handling_types | 0 | PRIMARY | 1 | handlingID | A | 17 | NULL | NULL | | BTREE | |
+-------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
1 row in set
Има три вида хора. Част от проблема, част от решението и част от пейзажа.
|
| |
|
|
|