Skip to content

Instantly share code, notes, and snippets.

@biot023

biot023/gist:1447223

Created December 8, 2011 15:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save biot023/1447223 to your computer and use it in GitHub Desktop.
Save biot023/1447223 to your computer and use it in GitHub Desktop.
Download ZIP
Indices on items table
Raw
gistfile1.txt
+-------+------------+------------------------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+-------+------------+------------------------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+
| items | 0 | PRIMARY | 1 | id | A | 689365 | NULL | NULL | | BTREE | |
| items | 0 | id | 1 | id | A | 689365 | NULL | NULL | | BTREE | |
| items | 0 | id | 2 | listed_at | A | 689365 | NULL | NULL | YES | BTREE | |
| items | 1 | index_items_on_user_id | 1 | user_id | A | 43085 | NULL | NULL | YES | BTREE | |
| items | 1 | listed_at | 1 | listed_at | A | 689365 | NULL | NULL | YES | BTREE | |
| items | 1 | expires_at | 1 | expires_at | A | 689365 | NULL | NULL | YES | BTREE | |
| items | 1 | status | 1 | status | A | 14 | NULL | NULL | YES | BTREE | |
| items | 1 | user_id | 1 | user_id | A | 49240 | NULL | NULL | YES | BTREE | |
| items | 1 | user_id | 2 | listed_at | A | 689365 | NULL | NULL | YES | BTREE | |
| items | 1 | status_itemtype | 1 | status | A | 173 | NULL | NULL | YES | BTREE | |
| items | 1 | status_itemtype | 2 | itemtype | A | 173 | NULL | NULL | YES | BTREE | |
| items | 1 | items_shop_and_shop_section_index | 1 | shop_id | A | 34468 | NULL | NULL | YES | BTREE | |
| items | 1 | items_shop_and_shop_section_index | 2 | shop_section_id | A | 98480 | NULL | NULL | YES | BTREE | |
| items | 1 | shop_section_id_index_2 | 1 | shop_section_id | A | 62669 | NULL | NULL | YES | BTREE | |
| items | 1 | created_at_index | 1 | created_at | A | 689365 | NULL | NULL | YES | BTREE | |
| items | 1 | index_items_on_default_currency_id | 1 | default_currency_id | A | 16 | NULL | NULL | YES | BTREE | |
| items | 1 | index_items_on_category_id | 1 | category_id | A | 16 | NULL | NULL | YES | BTREE | |
| items | 1 | index_items_on_subcategory_id | 1 | subcategory_id | A | 355 | NULL | NULL | YES | BTREE | |
| items | 1 | index_items_on_new_subcategory_id | 1 | new_subcategory_id | A | 300 | NULL | NULL | YES | BTREE | |
| items | 1 | index_items_on_place_id | 1 | place_id | A | 13 | NULL | NULL | YES | BTREE | |
+-------+------------+------------------------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment